Thank you! one more question, how can I know if one database has several schema?
> <don...@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 > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
