Hi Markus, That command gave the output below, this was after i created the scema, myschema; bash-2.05b$ psql -d emmet -c 'select * from pg_namespace' nspname | nspowner | nspacl ------------+----------+-------- pg_catalog | 1 | {=U} pg_toast | 1 | {=} public | 1 | {=UC} pg_temp_1 | 1 | myschema | 1 | (5 rows)