Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl

Am 20.03.23 um 15:02 schrieb richard coleman:
> Holger,
>
> Thanks, but I was looking for a SQL callable function(s), analogous to
> the Oracle  dbms_metadata.get_ddl() &
> dbms_metadata.get_dependent_ddl() functions that return DDL in plain
> text from an SQL query.
>
> It appears that PostgreSQL doesn't have that ability, at least not as
> a built-in function and with the suggestions of others on this list
> I'll have to write my own.
>
> Thanks again,
> rik.
>
Rik,

But you realize that on the other hand a PostgreSQL user switching to
Oracle could say:

"It appears that Oracle lacks PostgreSQL's proprietary views showing the
structure of the database."

Actually, nothing besides the ISO standard INFORMATION SCHEMA is in any
way standardised. The SQL standard is not comprehensive here and leaves
a lot to the implementor.

It's not difficult to write table-valued functions returning the DDL of
database objects, but it's a lot of work.

Regards,

Holger

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012