Re: SQL Command - To List Tables ?
От | Carmen Gloria Sepulveda Dedes |
---|---|
Тема | Re: SQL Command - To List Tables ? |
Дата | |
Msg-id | 3F4CAF4D.DE23478E@atichile.com обсуждение исходный текст |
Ответ на | SQL Command - To List Tables ? (Peter Moscatt <pgmoscatt@optushome.com.au>) |
Ответы |
Re: SQL Command - To List Tables ?
Re: SQL Command - To List Tables ? Re: SQL Command - To List Tables ? |
Список | pgsql-general |
Hello. I type \dt as user postgres, but it show only the tables within public schema. I need to know all tables (like v$_ or dba_ or user_ in oracle). How I do that? Thanks. Robby Russell wrote: > Peter Moscatt wrote: > >Is there a SQL command I can issue which will list all the TABLES within > >a database ? > > Well, when you are the postgres commandline client, you can type > # \dt > > That will show all the tables in your current database.
В списке pgsql-general по дате отправления: