Re: [GENERAL] schema name in SQL statement.

2008-08-20 Thread Lennin Caro
--- On Tue, 8/19/08, Masis, Alexander (US SSA) <[EMAIL PROTECTED]> wrote: > From: Masis, Alexander (US SSA) <[EMAIL PROTECTED]> > Subject: [GENERAL] schema name in SQL statement. > To: pgsql-general@postgresql.org > Date: Tuesday, August 19, 2008, 10:52 PM > I have to explicitly specify the sch

Re: [GENERAL] schema name in SQL statement.

2008-08-20 Thread Scott Marlowe
On Wed, Aug 20, 2008 at 8:13 AM, Adrian Klaver <[EMAIL PROTECTED]> wrote: > From postgresql.conf.sample in ~pgsql/share: > > > #--- > # CLIENT CONNECTION DEFAULTS > #-

Re: [GENERAL] schema name in SQL statement.

2008-08-20 Thread Adrian Klaver
On Tuesday 19 August 2008 9:53:11 pm johnf wrote: > On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote: > > -- Original message -- > > From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]> > > > > > I have to explicitly specify the schema name to make SQL sta

Re: [GENERAL] schema name in SQL statement.

2008-08-19 Thread Ow Mun Heng
-Original Message- From: johnf <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Subject: Re: [GENERAL] schema name in SQL statement. Date: Tue, 19 Aug 2008 22:25:14 -0700 On Tuesday 19 August 2008 10:06:55 pm Scott Marlowe wrote: > On Tue, Aug 19, 2008 at 10:53 PM, john

Re: [GENERAL] schema name in SQL statement.

2008-08-19 Thread johnf
On Tuesday 19 August 2008 10:06:55 pm Scott Marlowe wrote: > On Tue, Aug 19, 2008 at 10:53 PM, johnf <[EMAIL PROTECTED]> wrote: > > On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote: > >> From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]> > >> > >> > I have to explicitly specify the sche

Re: [GENERAL] schema name in SQL statement.

2008-08-19 Thread Scott Marlowe
On Tue, Aug 19, 2008 at 10:53 PM, johnf <[EMAIL PROTECTED]> wrote: > On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote: >> From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]> >> >> > I have to explicitly specify the schema name to make SQL statement to >> > work. >> > Can I set the schema

Re: [GENERAL] schema name in SQL statement.

2008-08-19 Thread johnf
On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote: > -- Original message -- > From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]> > > > I have to explicitly specify the schema name to make SQL statement to > > work. > > Can I set the schema before the quer

Re: [GENERAL] schema name in SQL statement.

2008-08-19 Thread Adrian Klaver
-- Original message -- From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]> > 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