Re: data dictionary?
От | Beth Gatewood |
---|---|
Тема | Re: data dictionary? |
Дата | |
Msg-id | 39EE04CE.1161AD4F@mbt.washington.edu обсуждение исходный текст |
Ответ на | Re: data dictionary? ("D. Duccini" <duccini@backpack.com>) |
Ответы |
Re: data dictionary?
("D. Duccini" <duccini@backpack.com>)
Re: data dictionary? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-novice |
So does this mean that there is no such thing as System Tables? I would really like to write some code that would be able to query any database, grab out the tables and then do a row count on each table. Obviously I could do this by hand, singly executing \dt but this will be taking a long time. Any thought on this? Thanks- Beth "D. Duccini" wrote: > its a good point. i use oracle almost daily for clients, and have been > thinking of writing a knock off of sqlplus to take oracle "concepts" like > "dual" or "sys.tab" > > > yes- I figured that was the case and why I sent it to novice ;-) > > > > I am referring to the the system tables (in Oracle the sql would be something > > like select * from user_tables". > > > > Thanks- > > Beth > > > > "D. Duccini" wrote: > > > > > if you can see them with \dt you can execute SQL against them ;) > > > > > > unless you're talking about system tables > > > > > > On Wed, 18 Oct 2000, Beth Gatewood wrote: > > > > > > > Hi- > > > > > > > > New to PostGreSQL...previously used Oracle. > > > > > > > > Could someone please tell me where the Data Dictionary is located? > > > > Specifically, I want to get a list of tables. I know about the \dt > > > > command but I would like to see where this is actually stored (so that I > > > > > > > > can execute SQL against it). > > > > > > > > TIA- > > > > > > > > Beth > > > > > > > > > > ----------------------------------------------------------------------------- > > > david@backpack.com BackPack Software, Inc. www.backpack.com > > > +1 651.645.7550 voice "Life is an Adventure. > > > +1 651.645.9798 fax Don't forget your BackPack!" > > > ----------------------------------------------------------------------------- > > > > ----------------------------------------------------------------------------- > david@backpack.com BackPack Software, Inc. www.backpack.com > +1 651.645.7550 voice "Life is an Adventure. > +1 651.645.9798 fax Don't forget your BackPack!" > -----------------------------------------------------------------------------
В списке pgsql-novice по дате отправления: