From: | "Phillip J(dot) Allen" <paallen(at)attglobal(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | How to list schemas and table in psql? |
Date: | 2003-01-10 00:50:49 |
Message-ID: | 3E1E18E9.508@attglobal.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all,
I just got the PG 7.3.1 installed and am now experimenting with
schemas. Now when I do a "\dt" in psql I only get a listing of tables
in the current schema (public by default).
So how do I get a listing in psql for:
1. all the schemas that exist in the database
2. all the tables in all schemas
I just came over to postgresql about 1 1/2 years ago from MS ACCESS and
now I am quite interested in schemas. I am trying to determine if I
want to put all my different databases into one big database under
different schemas (it makes sense considering my various databases often
use the same look-up/code table and keeping them all sincronized is a
bit of a pain). But before I go re-arranging all of my last years work
I think it would be wise to evaluate all the ins-and-outs first. No
reason to make more problems for myself.
Thanks,
Phillip J. Allen
Consulting Geochemist/Geologist
Lima Peru
e-mail: paallen(at)attglobal(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-01-10 03:47:51 | Re: How to list schemas and table in psql? |
Previous Message | Bruno Wolff III | 2003-01-10 00:38:54 | Re: [SQL] Search and Replace |