Re: schema name in SQL statement.

--- On Tue, 8/19/08, Masis, Alexander (US SSA) <alexander(dot)masis(at)baesystems(dot)com> wrote:

> From: Masis, Alexander (US SSA) <alexander(dot)masis(at)baesystems(dot)com>
> Subject: [GENERAL] schema name in SQL statement.
> To: pgsql-general(at)postgresql(dot)org
> Date: Tuesday, August 19, 2008, 10:52 PM
> 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"
>
>
>
> --
> Sent via pgsql-general mailing list
> (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

you can change the search path of the schema

SET search_path TO myschema