Re: how to show table structure?

use this

Last login: Fri Jan 9 16:54:14 from 192.168.2.117
[ssakkaravel(at)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(dot)marlowe(at)ihs(dot)com>
To: "Bing Du" <bdu(at)iastate(dot)edu>
Cc: <pgsql-sql(at)postgresql(dot)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