Re: Get name of columns in a table

From: Richard Huxton <dev(at)archonet(dot)com>
To: María Elena Hernández <mahelope(at)pereira(dot)multi(dot)net(dot)co>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Get name of columns in a table
Date: 2001-07-31 14:54:15
Message-ID: 3B66C697.FF4EC81B@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

María Elena Hernández wrote:
>
To get a list of columns, run "psql -E" and do a standard "\df foo"
where foo is your table name. This will show you exactly how PG does it.
I've found this very useful with all the backslash commands.

HTH

- Richard Huxton

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-07-31 15:14:03 Re: Dividing (and rounding) a date?
Previous Message Joel Burton 2001-07-31 14:45:18 Re: ----??? Random ???

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-07-31 15:16:43 Re: union in subselect?
Previous Message Gary Stainburn 2001-07-31 14:42:12 union in subselect?