Thread: About table schema
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/
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.