Thread: 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

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

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
>
>