About table schema

[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.

Thanks.

Wei

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Janning Vygen]

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 ma*******@postgresql.org

[Wei Shi]

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

Thanks.

Wei

--- Janning Vygen <vy***@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

ma*******@postgresql.org

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Mike Mascari]

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 ma*******@postgresql.org)

[Wei Shi]

This is great. Thanks.

Wei

--- Mike Mascari <ma*****@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

ma*******@postgresql.org)

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Richard Huxton]

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

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

[Peter Eisentraut]

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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings