Thread: Coming from Oracle SQL

Coming from Oracle SQL

From
Veronica L Bounmixay
Date:
<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>

Re: Coming from Oracle SQL

From
Michael Fuhr
Date:
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/


Re: Coming from Oracle SQL

From
Michael Fuhr
Date:
[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/


Re: Coming from Oracle SQL

From
Veronica L Bounmixay
Date:
<br /><font face="sans-serif" size="2">Thank you Mike - and SO SORRY all!  I'm a newbie to this forum and the style is
notcustomary to me!</font><br /><br /><font face="sans-serif" size="2">:-)</font><br /><br /><font face="sans-serif"
size="2">Thanksagain!</font><br /><font face="sans-serif" size="2">Ronni</font><br /><br /><br /><br /><table
width="100%"><trvalign="top"><td width="40%"><font face="sans-serif" size="1"><b>Michael Fuhr <mike@fuhr.org></b>
</font><p><fontface="sans-serif" size="1">04/25/2005 03:36 PM</font><table border="border"><tr valign="top"><td
bgcolor="white"><divalign="center"><font face="sans-serif" size="1">Please respond to<br />
pgsql-sql@postgresql.org</font></div></td></tr></table><br/></td><td width="59%"><table width="100%"><tr
valign="top"><td><divalign="right"><font face="sans-serif" size="1">To</font></div></td><td><font face="sans-serif"
size="1">VeronicaL Bounmixay <Veronica.Bounmixay@inl.gov></font></td></tr><tr valign="top"><td><div
align="right"><fontface="sans-serif" size="1">cc</font></div></td><td><font face="sans-serif"
size="1">pgsql-sql@postgresql.org</font></td></tr><trvalign="top"><td><div align="right"><font face="sans-serif"
size="1">Subject</font></div></td><td><fontface="sans-serif" size="1">Re: [SQL] Coming from Oracle
SQL</font></td></tr></table><br/><table><tr valign="top"><td></td><td></td></tr></table><br /></td></tr></table><br
/><br/><br /><font size="2"><tt>[Please copy the mailing list on replies so others can contribute<br /> to and learn
fromdiscussions.]<br /><br /> On Mon, Apr 25, 2005 at 09:31:35AM -0600, Veronica L Bounmixay wrote:<br /> > <br />
>Thank you so much for responding.  I did dig around until I was able to <br /> > find pg_tables but I must be
extremelystupid.  I'm using 8.0.2 and I <br /> > noticed that my download includes the docs - how the heck do I get
to<br /> > them?  I'm just using the psql interactive terminal.<br /><br /> If the doc is a bunch of HTML files then
youcan view them with a<br /> browser, either by serving them via a web server or by using a file<br /> URL.  For
example,if the files are under /path/to/files then you<br /> could view the doc with
file:///path/to/files/index.html.<br/><br /> > Also, what did you mean by "if you're using psql?"  Is there any
other? I <br /> > really would like to find that out.  I know I'm stupid on that part!<br /><br /> psql is the
standardclient but third-party clients exist.  Some<br /> people, for example, like pgAdmin III.<br /><br /> -- <br />
MichaelFuhr<br /> http://www.fuhr.org/~mfuhr/<br /></tt></font><br />