About table schema

Am Mittwoch, 26. Mai 2004 00:36 schrieb Wei Shi:

Hi, does anyone know how to get the schema information
of a table. More specifically, I would like to know

1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is referring to.

connect to your database with 'psql' and type

\d tablename

which gives you all information you asked for. Type \? for a list of other
commands within psql and take a look at 'man psql'

kind regards,
janning

Is there a function interface to get this information
other than from "psql" comman line interface?

Thanks.

Wei

--- Janning Vygen <vygen@gmx.de> wrote:

Am Mittwoch, 26. Mai 2004 00:36 schrieb Wei Shi:

Hi, does anyone know how to get the schema

information

of a table. More specifically, I would like to

know

1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table

it

is referring to.

connect to your database with 'psql' and type

\d tablename

which gives you all information you asked for. Type
\? for a list of other
commands within psql and take a look at 'man psql'

kind regards,
janning

---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to

majordomo@postgresql.org

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

Wei Shi wrote:

Is there a function interface to get this information
other than from "psql" comman line interface?

If you start psql with the '-E' switch, you'll see the queries it
generates to display the meta-data associated with the '\' command
you issue.

You may also query the tables and views in the information_schema
for what you want.

Mike Mascari

This is great. Thanks.

Wei

--- Mike Mascari <mascarm@mascari.com> wrote:

Wei Shi wrote:

Is there a function interface to get this

information

other than from "psql" comman line interface?

If you start psql with the '-E' switch, you'll see
the queries it
generates to display the meta-data associated with
the '\' command
you issue.

You may also query the tables and views in the
information_schema
for what you want.

Mike Mascari

---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
unregister command
(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

Wei Shi wrote:

This is great. Thanks.

There is also the information schema in 7.4, e.g. "SELECT * FROM
information_schema.tables"

There's not as much detail there, but it's supposed to be standard
across different database systems.

--
Richard Huxton
Archonet Ltd

Wei Shi wrote:

Hi, does anyone know how to get the schema information
of a table. More specifically, I would like to know

1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is referring to.

Use the information schema views.