RE: Data Types

\d tablename

Pat

-----Original Message-----
From: syed asghar [mailto:abemail1(at)yahoo(dot)co(dot)uk]
Sent: Thursday, July 27, 2000 9:09 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Data Types

Hello again,

Thanks everyone for your help re: backup.

If you are given a database and you need info about eg
what field types were specified - How do you do this?

I know you can list all tables with \d command and the
table contents with a select.. but I can't seem to
figure out how to find out what data types are used.

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie