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

From sunpeng
Subject when i logged in mydb,any sql command used to list all the tables in this mydb?
Date
Msg-id g2g46cc57ac1004081434s947f1113p983efdaa9217cd65@mail.gmail.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: sunpeng
Date:
Subject: how to debug the codes in the PostgresMain() from the begining of this function to the "for (;;)" loop that handles the connection?
Next
From: Simon Riggs
Date:
Subject: Re: Postgres doesn't seem to enforce array dimensions