From: | René Romero Benavides <ichbinrene(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: describe command for |
Date: | 2012-06-08 19:44:08 |
Message-ID: | 4FD25608.1060603@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Am 08.06.2012 14:31, schrieb Little, Douglas:
>
> Is there a postgres sql command/function that will display an object ddl?
>
> I know of the psql metacharacters, but don't know how I'd submit from
> a non-psql client like sqldbx.
>
> I see that pgadmin generates a query and then formats into a ddl
> statement, but this seems like a lot of work for something that I
> would expect to be part of the command set.
>
> Thanks
>
> *Doug Little*
>
> **
>
> Sr. Data Warehouse Architect | Business Intelligence Architecture |
> Orbitz Worldwide
>
> 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 |
> Fax 312.894.5164 | Cell 847-997-5741
>
> *Douglas(dot)Little(at)orbitz(dot)com* <mailto:Douglas(dot)Little(at)orbitz(dot)com>*__*
>
> Description: cid:image001(dot)jpg(at)01CABEC8(dot)D4980670 orbitz.com
> <http://www.orbitz.com/> | ebookers.com <http://www.ebookers.com/> |
> hotelclub.com <http://www.hotelclub.com/> | cheaptickets.com
> <http://www.cheaptickets.com/> | ratestogo.com
> <http://www.ratestogo.com/>| asiahotels.com <http://www.asiahotels.com/>
>
Use pg_dump , you can define for what tables you want it to generate ddl
for (check the -n and -t options) . If you pass it a -s OR --schema-only
it will only dump data definitions (ddl).
--
pglearn.blogspot.mx:postgresql recipes <http://pglearn.blogspot.mx/>
*Twitter*.You might consider to follow *(at)sqlhotfix*
From | Date | Subject | |
---|---|---|---|
Next Message | Bartosz Dmytrak | 2012-06-08 19:50:48 | Re: describe command for |
Previous Message | Little, Douglas | 2012-06-08 19:31:08 | describe command for |