PostgreSQL中，如何查表属于哪个数据库
db1=# \x
Expanded display is on.
db1=# SELECT * FROM information_schema.tables WHERE table_name='tab100';
-[ RECORD 1 ]----------------+-----------
table_catalog | db1
table_schema | public
table_name | tab100
table_type | BASE TABLE
self_referencing_column_name |
reference_generation |
user_defined_type_catalog |
user_defined_type_schema |
user_defined_type_name |
is_insertable_into | YES
is_typed | NO
commit_action |
db1=# \x
Expanded display is off.
db1=#
posted @
2013-07-04 11:34
健哥的数据花园
阅读(2543)
评论(0)
收藏
举报