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