schema name in SQL statement.

From: "Masis, Alexander \(US SSA\)" <alexander(dot)masis(at)baesystems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: schema name in SQL statement.
Date: 2008-08-19 22:52:27
Message-ID: 737og9$v32j@dmzms99902.na.baesystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2008-08-19 23:01:55 Re: schema name in SQL statement.
Previous Message Glen Parker 2008-08-19 22:16:03 Re: WAL archiving to network drive