How to list schemas and table in psql?
От | Phillip J. Allen |
---|---|
Тема | How to list schemas and table in psql? |
Дата | |
Msg-id | 3E1E18E9.508@attglobal.net обсуждение исходный текст |
Ответы |
Re: How to list schemas and table in psql?
Re: How to list schemas and table in psql? |
Список | 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@attglobal.net
В списке pgsql-novice по дате отправления: