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/