Search Postgresql Archives
when i logged in mydb,any sql command used to list all the tables in this mydb?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]