Re: What's the CURRENT schema ? - Mailing list pgsql-hackers

From Joe Conway
Subject Re: What's the CURRENT schema ?
Date
Msg-id 3CABDC61.3000605@joeconway.com
Whole thread Raw
In response to What's the CURRENT schema ?  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-hackers
Tom Lane wrote:
> PUBLIC is a reserved keyword, so you have to do something like
>     select * from "public".vs1;
> if there is a vs1 hiding it in an earlier namespace in the search
> path.
> 
> I've been vacillating about whether to choose another name for the
> public namespace to avoid the need for quotes here.  I can't think
> of another good name :-(
> 


What about shared.vs1 or common.vs1?

Joe




pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Changing column types...
Next
From: Peter Eisentraut
Date:
Subject: Re: What's the CURRENT schema ?