psql option for writing schema
psql option for writing schema
От:
reina@nsi.edu (Tony Reina)
Дата:
I seem to remember a psql option that dumped out the table schema. I can't seem to find it in the man for psql. Could someone point out the option to me? Thanks. -Tony
Re: psql option for writing schema
От:
reina@nsi.edu (Tony Reina)
Дата:
missive@frontiernet.net (Lee Harr) wrote in message news:<9ubpl9$196u$1@news.tht.net>... > On 30 Nov 2001 10:52:26 -0800, Tony Reina wrote: > > I seem to remember a psql option that dumped out the table schema. I > > can't seem to find it in the man for psql. Could someone point out the > > option to me? > > > > In psql \? is your friend. > > Probably what you want is \d tableName No. I know that one. I had thought it was a psql option, but what I wanted was actually a pg_dump option called '--schema-only'. pg_dump --schema-only db_name Thanks for the help anyway. -Tony
Re: psql option for writing schema
От:
missive@frontiernet.net (Lee Harr)
Дата:
On 30 Nov 2001 10:52:26 -0800, Tony Reina wrote: > I seem to remember a psql option that dumped out the table schema. I > can't seem to find it in the man for psql. Could someone point out the > option to me? > In psql \? is your friend. Probably what you want is \d tableName