--- On Tue, 8/19/08, Masis, Alexander (US SSA) <alexander.masis@xxxxxxxxxxxxxx> wrote: > From: Masis, Alexander (US SSA) <alexander.masis@xxxxxxxxxxxxxx> > Subject: [GENERAL] schema name in SQL statement. > To: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > 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
