From: Kumar <sgnerd@yahoo.com.sg>
To: scott.marlowe <scott.marlowe@ihs.com>
To: Bing Du <bdu@iastate.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to show table structure?
Date: Sat, 10 Jan 2004 09:33:51 +0530
Message-ID: <005f01c3d72e$c66919f0$7502a8c0@hdsc.com> (raw)
References: <Pine.LNX.4.33.0401091608580.6872-100000@css120.ihs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg, scott.marlowe@ihs.com, bdu@iastate.edu
Subject: Re: how to show table structure?
In-Reply-To: <005f01c3d72e$c66919f0$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox