Postgres Pro
Downloads
Home   >   mailing lists

DDL from psql console? - Mailing list pgsql-general

From John Browne
Subject DDL from psql console?
Date
Msg-id ccc6061050425082963907ad9@mail.gmail.com
Whole thread Raw
Responses Re: DDL from psql console?  (Thomas F.O'Connell <tfo@sitening.com>)
Re: DDL from psql console?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: DDL from psql console?  (John Browne <jkbrowne@gmail.com>)
Re: DDL from psql console?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hello,

I was curious if there was a way to get the DDL for a particular table
from the psql client console?  I have two postgres boxes (development
and production) and would like to copy & paste the DDL "CREATE TABLE"
statements from the development console to the production console when
I'm moving a particular table definition over.  I tried \dt+ but it
didn't appear to show it.

Any thoughts?

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: timezone() with timeofday() converts the wrong direction?
Next
From: Akbar
Date:
Subject: installation as service failed on windows xp