Re: DDL from psql console?

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: John Browne <jkbrowne(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: DDL from psql console?
Date: 2005-04-25 15:41:07
Message-ID: 757535eee398c971de05f2e6a5f62cff@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Any reason not to use pg_dump -s?

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Apr 25, 2005, at 10:29 AM, John Browne wrote:

> 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-04-25 15:41:49 Re: DDL from psql console?
Previous Message Tom Lane 2005-04-25 15:36:23 Re: timezone() with timeofday() converts the wrong direction?