Skip site navigation (1) Skip section navigation (2)

Re: Getting Column Information from a Table with psql

From: Mohan <mohanyes(at)shafika(dot)vetri(dot)com>
To: Kevin Lohka <klohka(at)aboutfacedata(dot)ab(dot)ca>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Getting Column Information from a Table with psql
Date: 2004-03-09 06:10:43
Message-ID: 404D5FE3.2BB739E0@shafika.vetri.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Kevin,
use
\d [Tablename]
to get the detalis of all the columns in the table.  It will also give the
Index, Primary key and Triger details.
Regards,
mohan

Kevin Lohka wrote:

> Is there any way to get the column information from a Table with psql?
>
> I know it is possible to get a list of Tables in the database using \dt
> is there a similar command for column information?
>
> If not are there any alternatives?
>
> Thanks for the help.
>
> Kevin Lohka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


In response to

pgsql-novice by date

Next:From: stm23Date: 2004-03-09 06:14:15
Subject: JDBC driver & local server
Previous:From: Kevin LohkaDate: 2004-03-09 05:59:19
Subject: Getting Column Information from a Table with psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group