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

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

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