Re: Coming from Oracle SQL

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/