Postgres Pro
Downloads
Home   >   mailing lists

Re: DDL from psql console? - Mailing list pgsql-general

From Tom Lane
Subject Re: DDL from psql console?
Date
Msg-id 19585.1114444140@sss.pgh.pa.us
Whole thread Raw
In response to DDL from psql console?  (John Browne <jkbrowne@gmail.com>)
Responses Re: DDL from psql console?
List pgsql-general
Tree view 
John Browne <jkbrowne@gmail.com> writes:
> I was curious if there was a way to get the DDL for a particular table
> from the psql client console?

No.  Try
    pg_dump -s -t tablename dbname

            regards, tom lane

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Hosting Service Recommendations
Next
From: Michael Fuhr
Date:
Subject: Re: DDL from psql console?