> postgres=# select version(); > version > > > --------------------------------------------------------------------------------------------------------------- > PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 > 20080704 (Red Hat 4.1.2-52), 64-bit > (1 row) > > postgres=# \dn > List of schemas > Name | Owner > --------------------+---------- > information_schema | postgres > pg_catalog | postgres > pg_toast | postgres > pg_toast_temp_1 | postgres > public | postgres > (5 rows) > > Apart from your actual question, am just curious to see this output, how come all schema's displayed whereas in latest releases only PUBLIC schema will be displayed if you use meta command \dn.
-bash-4.1$ ./psql -p 5555 psql (9.3beta1) Type "help" for help. postgres=# \dn List of schemas Name | Owner --------+---------- public | postgres (1 row) --Raghav
