pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedComing from Oracle SQL
4+ messages / 2 participants
[nested] [flat]
* Coming from Oracle SQL
@ 2005-04-19 15:37 Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
2005-04-23 05:29 ` Re: Coming from Oracle SQL Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 4+ messages in thread
From: Veronica L Bounmixay @ 2005-04-19 15:37 UTC (permalink / raw)
To: pgsql-sql
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;
Thank you for the help - you will never know how appreciated it is!
Ronni
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Coming from Oracle SQL
2005-04-19 15:37 Coming from Oracle SQL Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
@ 2005-04-23 05:29 ` Michael Fuhr <mike@fuhr.org>
2005-04-25 21:36 ` Re: Coming from Oracle SQL Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Fuhr @ 2005-04-23 05:29 UTC (permalink / raw)
To: Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>; +Cc: pgsql-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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Coming from Oracle SQL
2005-04-19 15:37 Coming from Oracle SQL Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
2005-04-23 05:29 ` Re: Coming from Oracle SQL Michael Fuhr <mike@fuhr.org>
@ 2005-04-25 21:36 ` Michael Fuhr <mike@fuhr.org>
2005-04-25 21:45 ` Re: Coming from Oracle SQL Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Fuhr @ 2005-04-25 21:36 UTC (permalink / raw)
To: Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>; +Cc: pgsql-sql
[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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Coming from Oracle SQL
2005-04-19 15:37 Coming from Oracle SQL Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
2005-04-23 05:29 ` Re: Coming from Oracle SQL Michael Fuhr <mike@fuhr.org>
2005-04-25 21:36 ` Re: Coming from Oracle SQL Michael Fuhr <mike@fuhr.org>
@ 2005-04-25 21:45 ` Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Veronica L Bounmixay @ 2005-04-25 21:45 UTC (permalink / raw)
To: pgsql-sql; +Cc: mike@fuhr.org
Thank you Mike - and SO SORRY all! I'm a newbie to this forum and the
style is not customary to me!
:-)
Thanks again!
Ronni
Michael Fuhr <mike@fuhr.org>
04/25/2005 03:36 PM
Please respond to
pgsql-sql@postgresql.org
To
Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
cc
pgsql-sql@postgresql.org
Subject
Re: [SQL] Coming from Oracle SQL
[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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-04-25 21:45 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-19 15:37 Coming from Oracle SQL Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
2005-04-23 05:29 ` Michael Fuhr <mike@fuhr.org>
2005-04-25 21:36 ` Michael Fuhr <mike@fuhr.org>
2005-04-25 21:45 ` Veronica L Bounmixay <Veronica.Bounmixay@inl.gov>
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