Admin tutorials?
Admin tutorials?
От:
lbottorff@harveycounty.com
Дата:
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?
От:
Michael Davis <mdavis@sevainc.com>
Дата:
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?
От:
Jie Liang <jliang@ipinc.com>
Дата:
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 > >