Re: SQL question

On Monday 09 Jun 2003 2:30 pm, Guillaume Houssay wrote:
> I found a way to have the list of all the tables for my database.
>
> Now, I would like to get the name of the columns of any table.
> I could not find the SQL command to do that.
>
> Thank you for you help

In psql there are a number of backslash commands - you might find the
following useful:

\d
\dt
\dv
\d mytable1
\d my*

If you start psql with the -E flag you'll see the SQL that's used to run
these. See "man psql" or the manuals for more info.

--
  Richard Huxton