From: Michael Fuhr <mike@fuhr.org>
To: Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: Coming from Oracle SQL
Date: Fri, 22 Apr 2005 23:29:59 -0600
Message-ID: <20050423052959.GB96630@winnie.fuhr.org> (raw)
In-Reply-To: <OF7B5D560B.8724057C-ON87256FE8.00559430-87256FE8.0055D0BE@inel.gov>
References: <OF7B5D560B.8724057C-ON87256FE8.00559430-87256FE8.0055D0BE@inel.gov>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, Veronica.Bounmixay@inl.gov
Subject: Re: Coming from Oracle SQL
In-Reply-To: <20050423052959.GB96630@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox