Re: Schema (Search path issue) on PostgreSQL9.2

> 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