when i logged in mydb,any sql command used to list all the tables in this mydb?

Поиск
Список
Период
Сортировка
От sunpeng
Тема when i logged in mydb,any sql command used to list all the tables in this mydb?
Дата
Msg-id g2g46cc57ac1004081434s947f1113p983efdaa9217cd65@mail.gmail.com
обсуждение исходный текст
Ответы Re: when i logged in mydb,any sql command used to list all the tables in this mydb?  (Diego Schulz <dschulz@gmail.com>)
Re: when i logged in mydb,any sql command used to list all the tables in this mydb?  (Kenichiro Tanaka <ketanaka@ashisuto.co.jp>)
Список pgsql-general
once i have created mydb and several relations in it,are there any sql commands used to list all the tables in this mydb?
i noticed there are no database( pg_database.oid) field in pg_class table,so i can not use
select relname from pg_class,pg_database where pg_database.datname like 'mydb' and pg_class.database = pg_database.oid;
anybody knows how to do it?
another question:how postgresql internal knows which relations belongs to which database?

thanks

В списке pgsql-general по дате отправления:

Предыдущее
От: sunpeng
Дата:
Сообщение: how to debug the codes in the PostgresMain() from the begining of this function to the "for (;;)" loop that handles the connection?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Postgres doesn't seem to enforce array dimensions