Postgres Pro
Downloads
Home   >   mailing lists

Re: Schema (Search path issue) on PostgreSQL9.2 - Mailing list pgsql-general

From Raghavendra
Subject Re: Schema (Search path issue) on PostgreSQL9.2
Date
Msg-id CA+h6AhhZgvV6XsLgrm8rvdPSem9J9A8Fb8WcWYZmiO99=eey9Q@mail.gmail.com
Whole thread Raw
In response to Schema (Search path issue) on PostgreSQL9.2  (chiru r <chirupg@gmail.com>)
List pgsql-general
Tree view

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


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Tuning read ahead
Next
From: Ioana Danes
Date:
Subject: Re: Running out of memory on vacuum