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

From: sunpeng <bluevaley(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: when i logged in mydb, any sql command used to list all the tables in this mydb?
Date: 2010-04-08 21:34:14
Message-ID: g2g46cc57ac1004081434s947f1113p983efdaa9217cd65@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sunpeng 2010-04-08 21:34:56 how to debug the codes in the PostgresMain() from the begining of this function to the "for (;;)" loop that handles the connection?
Previous Message Corin 2010-04-08 20:54:38 Re: fulltext search stemming/ spelling problems