use this
Last login: Fri Jan 9 16:54:14 from 192.168.2.117
[ssakkaravel@Linuxsvr ssakkaravel]$ psql -E training test
********* QUERY **********
SELECT usesuper FROM pg_user WHERE usename = 'test'
**************************
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands
\g or terminate with semicolon to execute query \q to quit
training=# \d books
********* QUERY **********
SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
FROM pg_class WHERE relname='books'
**************************
********* QUERY **********
SELECT a.attname, format_type(a.atttypid, a.atttypmod), a.attnotnull,
a.atthasdef, a.attnu
m
FROM pg_class c, pg_attribute a
WHERE c.relname = 'books' AND a.attnum > 0 AND a.attrelid = c.oid
ORDER BY a.attnum
**************************
********* QUERY **********
SELECT substring(d.adsrc for 128) FROM pg_attrdef d, pg_class c
WHERE c.relname = 'books' AND c.oid = d.adrelid AND d.adnum = 1
**************************
Table "books" Column | Type |
Modifiers
-------------+-----------------------+--------------------------------------
--------------
--bid | integer | not null default
nextval('test.books_bid_seq'::text
)bname | character varying(20) |price | money |publication | date |
----- Original Message -----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: "Bing Du" <bdu@iastate.edu>
Cc: <pgsql-sql@postgresql.org>
Sent: Saturday, January 10, 2004 4:40 AM
Subject: Re: [SQL] how to show table structure?
> On Fri, 9 Jan 2004, Bing Du wrote:
>
> > Greetings,
> >
> > How can I see the layout of a table in PostgreSQL 7.4? I've checked
> > several books and on-line documents, but was not able to figure out how
> > PostgreSQL does 'describe <table>' like it's done in other databases.
>
> If in psql, use the \d commands (\? will show you all of them.
>
> However, if you've not got psql to do it, you can look through the
> information_schema for anything like that, like so:
>
> select * from information_schema.tables;
>
> and so on.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
