Re: SQL question - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: SQL question
Date
Msg-id 20030610053242.GC18095@svana.org
Whole thread Raw
In response to SQL question  ("Guillaume Houssay" <ghoussay@noos.fr>)
List pgsql-general
On Mon, Jun 09, 2003 at 03:30:33PM +0200, 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.

In psql type \? to get a list of all the commands. In particular, \d
<tablename> is what you're looking for.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Estimate of when CVS will be available again?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Trouble to understand plain of postgresql