<donghe(at)caltech(dot)edu> 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