Re: data dictionary?
От | D. Duccini |
---|---|
Тема | Re: data dictionary? |
Дата | |
Msg-id | Pine.GSO.4.03.10010181516200.14181-100000@ra.bpsi.net обсуждение исходный текст |
Ответ на | Re: data dictionary? (Beth Gatewood <bethg@mbt.washington.edu>) |
Список | pgsql-novice |
oh no, there are system tables check out /dS On Wed, 18 Oct 2000, Beth Gatewood wrote: > 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!" > > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- 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 по дате отправления: