Search Postgresql Archives

Re: schema name in SQL statement.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday 19 August 2008 10:06:55 pm Scott Marlowe wrote:
> On Tue, Aug 19, 2008 at 10:53 PM, johnf <jfabiani@xxxxxxxx> wrote:
> > On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote:
> >> From: "Masis, Alexander (US SSA)" <alexander.masis@xxxxxxxxxxxxxx>
> >>
> >> > I have to explicitly specify the schema name to make SQL statement to
> >> > work.
> >> > Can I set the schema before the query, or set a default schema?
> >> > My current statement:
> >> > "SELECT col FROM schema.table"
> >> > I like to be able to use generic SQL statement like:
> >> > "SELECT col FROM table"
> >>
> >> See search_path in:
> >> http://www.postgresql.org/docs/8.3/interactive/runtime-config-client.htm
> >>l
> >
> > I see answers like this all the time.  When I review the doc's I still
> > don't know how to set the "search_path" because there is no example in
> > the doc's. Do I do something like this:
> > "select search_path=(public)"  or "select search_path="public" .  So how
> > is the search_path set?
>
> But there is a link on that page under search_path that points here:
>
> http://www.postgresql.org/docs/8.3/interactive/ddl-schemas.html
>
> which has much better info on search_path in it.

Thanks - I did not note the link.  

-- 
John Fabiani


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux