Обсуждение: Coming from Oracle SQL

<br /><font face="sans-serif" size="2">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
findtables in Oracle by using the following query and hoped to find a replacement.  Better would be someplace to
referencethese sorts of "key" tables, etc that keep track of the indexes, tables, columns and more.</font><br /><br
/><fontface="sans-serif" size="2">select distinct table_name from all_tables;</font><br /><br /><font face="sans-serif"
size="2">Thankyou for the help - you will never know how appreciated it is!</font><br /><font face="sans-serif"
size="2">Ronni</font>

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/

[Please copy the mailing list on replies so others can contribute
to and learn from discussions.]

On Mon, Apr 25, 2005 at 09:31:35AM -0600, Veronica L Bounmixay wrote:
> 
> Thank you so much for responding.  I did dig around until I was able to 
> find pg_tables but I must be extremely stupid.  I'm using 8.0.2 and I 
> noticed that my download includes the docs - how the heck do I get to 
> them?  I'm just using the psql interactive terminal.

If the doc is a bunch of HTML files then you can view them with a
browser, either by serving them via a web server or by using a file
URL.  For example, if the files are under /path/to/files then you
could view the doc with file:///path/to/files/index.html.

> Also, what did you mean by "if you're using psql?"  Is there any other?  I 
> really would like to find that out.  I know I'm stupid on that part!

psql is the standard client but third-party clients exist.  Some
people, for example, like pgAdmin III.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/