On Tue, Apr 19, 2005 at 09:37:19AM -0600, Veronica L Bounmixay wrote: > > I have a dumb question to ask - as I'm certain all of my future ones will > be as well. I am coming from the Oracle SQL PL/SQL side of things and > trying to get wrapped around PostgreSQL. I used to find tables in Oracle > by using the following query and hoped to find a replacement. Better > would be someplace to reference these sorts of "key" tables, etc that keep > track of the indexes, tables, columns and more. > > select distinct table_name from all_tables;
See the "System Catalogs" and "The Information Schema" chapters in the documentation. If you're using psql, see the "Meta-Commands" section in its documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
