PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
От | richard coleman |
---|---|
Тема | PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl |
Дата | |
Msg-id | CAGA3vBt=an4RqygEvUeeLPB_s0W92hC2DtjFmxV2eKu93NWOKA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl |
Список | pgsql-admin |
Hello all,
I am trying to find a simple way to get access the DDL information for PostgreSQL tables, constraints, and indices via SQL.
In Oracle there are the dbms_metadata.get_ddl() and dbms_metadata.get_dependent_ddl() functions that you can call on dual to get this information.
EX:
-- table DDL:
select dbms_metadata.get_ddl('TABLE', 'MY_TABLE','MY_SCHEMA') as "table_ddl" from dual;
-- indices DDL
select dbms_metadata.get_dependent_ddl('INDEX','MY_TABLE','MY_SCHEMA') as "table_indicies" from dual;
-- constraints DDL
select dbms_metadata.get_dependent_ddl('CONSTRAINT','MY_TABLE','MY_SCHEMA') as "constraints_ddl" from dual;
select dbms_metadata.get_dependent_ddl('INDEX','MY_TABLE','MY_SCHEMA') as "table_indicies" from dual;
-- constraints DDL
select dbms_metadata.get_dependent_ddl('CONSTRAINT','MY_TABLE','MY_SCHEMA') as "constraints_ddl" from dual;
Is there an equivalent function to do the same in PostgreSQL?
I know there are ways via pg_dump and psql, but what I need is a way to do so via SQL.
Thanks,
rik.
В списке pgsql-admin по дате отправления: