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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly