On Sun, Feb 14, 2010 at 05:08:05PM +0100, Yeb Havinga wrote: > Little, Douglas wrote: > > > >Hi, > > > > > > > >Is there a PG command or fuction that will return table ddl? > > > If you just want the definition,in psql type \d tablename. > To dump ddl the pg_dump with proper arguments can dump just the ddl of a > single table. (see pg_dump --help)
more of a pg-users question, but since we've got a partial answer here, might as well complete it. Try psql -E, then \d sometable to see the commands psql issues to generate its display. Ross -- Ross Reedstrom, Ph.D. reeds...@rice.edu Systems Engineer & Admin, Research Scientist phone: 713-348-6166 The Connexions Project http://cnx.org fax: 713-348-3665 Rice University MS-375, Houston, TX 77005 GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
