[ADMIN] why schema name is same as username behaves different then others

2002-12-05 Thread Jie Liang
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

Re: [ADMIN] why schema name is same as username behaves different then others

2002-12-05 Thread Tom Lane
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