From: Tom Lane <tgl@sss.pgh.pa.us>
To: richard coleman <rcoleman.ascentgl@gmail.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl &
 dbms_metadata.get_dependent_ddl
In-reply-to: 
 <CAGA3vBt=an4RqygEvUeeLPB_s0W92hC2DtjFmxV2eKu93NWOKA@mail.gmail.com>
References: 
 <CAGA3vBt=an4RqygEvUeeLPB_s0W92hC2DtjFmxV2eKu93NWOKA@mail.gmail.com>
Comments: In-reply-to richard coleman <rcoleman.ascentgl@gmail.com>
	message dated "Sun, 19 Mar 2023 17:36:17 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <803986.1679264801.1@sss.pgh.pa.us>
Date: Sun, 19 Mar 2023 18:26:41 -0400
Message-ID: <803987.1679264801@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/803987.1679264801%40sss.pgh.pa.us>
Precedence: bulk

richard coleman <rcoleman.ascentgl@gmail.com> writes:
> I am trying to find a simple way to get access the DDL information for
> PostgreSQL tables, constraints, and indices via SQL.

There are bits of that, but it's not terribly complete or consistent
because nobody's made a concerted effort to build stuff that wasn't
driven by "what does pg_dump need".  (And what pg_dump needs, for
the most part, is not simply "give me all the DDL for this object
in a black box".)

I'd suggest taking a look at the pg_get_* functions, which are
mostly documented at

https://www.postgresql.org/docs/current/functions-info.html

There are some other things on that page that might help, too.

			regards, tom lane