Thread: Admin tutorials?

Admin tutorials?

From
lbottorff@harveycounty.com
Date:
I've looked at psql and found good stuff, but I still don't know how to get a
listing of all my tables. I know in Oracle it's a SELECT statement, and I take
it for granted a lot of admin is done with regular SQL commands, where can I
learn such stuff as how to list my tables?

LB



RE: Admin tutorials?

From
Michael Davis
Date:
In psql, type \dS.  This will report all the system tables.

For example:

Select * from pg_tables;

Will select info on all your tables.

Here is a link that describes most of the system tables:

http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm



-----Original Message-----
From:    lbottorff@harveycounty.com [SMTP:lbottorff@harveycounty.com]
Sent:    Saturday, January 27, 2001 10:24 AM
To:    pgsql-admin@postgresql.org
Subject:    Admin tutorials?

I've looked at psql and found good stuff, but I still don't know how to get a
listing of all my tables. I know in Oracle it's a SELECT statement, and I take
it for granted a lot of admin is done with regular SQL commands, where can I
learn such stuff as how to list my tables?

LB



Re: Admin tutorials?

From
Jie Liang
Date:
Hi,

use \dt

BTW,
use \? to all commands.



Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com

On Sat, 27 Jan 2001 lbottorff@harveycounty.com wrote:

> I've looked at psql and found good stuff, but I still don't know how to get a
> listing of all my tables. I know in Oracle it's a SELECT statement, and I take
> it for granted a lot of admin is done with regular SQL commands, where can I
> learn such stuff as how to list my tables?
>
> LB
>
>