<donghe@xxxxxxxxxxx> wrote:
> when I use #\d, it only list tables of public schema, how can I
> see/access non-public schema in a database?
Include the schema on your search_path or specify it on your \d
command. For example:
cir=> \dt information_schema.*
List of relations
Schema | Name | Type | Owner
--------------------+-------------------------+-------+-------
information_schema | sql_features | table | ccsa
information_schema | sql_implementation_info | table | ccsa
information_schema | sql_languages | table | ccsa
information_schema | sql_packages | table | ccsa
information_schema | sql_parts | table | ccsa
information_schema | sql_sizing | table | ccsa
information_schema | sql_sizing_profiles | table | ccsa
(7 rows)
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
