Thank you!
one more question, how can I know if one database has several schema?
> <donghe@caltech.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
>