Note:
test=# super user postgres
test= regular user robot
### comments
test=#create schema t AUTHORIZATION robot;
CREATE SCHEMA
test= select * from pg_namespace ;
nspname | nspowner | nspacl
+--+
pg_catalog |1 | {=U}
pg_toast |1 | {=}
public
Jie Liang [EMAIL PROTECTED] writes:
I expect to see something like:
You're neglecting the effects of search path. \dt only shows what's
visible in your search path. (IIRC, \dt *.* is the easiest way to
see all tables regardless of search path.)
it seems if schema name is same as