Hi peng
> According to 8.4 document 44.1(Most system catalogs are
> copied from the template database during database creation and are
thereafter database
> -specific.),we know that each created database has their own pg_...
tables
I believe it is right.
> and thus if a superuser admini
hi,Kenichiro,
Thanks for your answer!
Then another question comes: According to 8.4 document 44.1(Most system
catalogs are copied from the template database during database creation and
are thereafter database-specific.),we know that each created database has
their own pg_... tables and thus i
Hello sunpeng
First,I answer this question.
>another question:how postgresql internal knows which
>relations belongs to which database?
When we use "psql" command ,it means "psql -d postgres".
#you can change default parameter to set PGDATABASE (OS parameter)
"-d" indicate your connecting datab
On Thu, Apr 8, 2010 at 6:34 PM, sunpeng wrote:
> 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
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_
