Thread: psql option for writing schema

psql option for writing schema

From
reina@nsi.edu (Tony Reina)
Date:
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

From
reina@nsi.edu (Tony Reina)
Date:
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 <reina@nsi.edu> 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

From
missive@frontiernet.net (Lee Harr)
Date:
On 30 Nov 2001 10:52:26 -0800, Tony Reina <reina@nsi.edu> 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