From: Masis, Alexander \(US SSA\) <alexander.masis@baesystems.com>
To: pgsql-interfaces@postgresql.org
Subject: schema name in the SQL statement.
Date: Tue, 19 Aug 2008 18:43:27 -0400
Message-ID: <738m08$3l61o@dmzms99802.na.baesystems.com> (raw)
My db has one schema. In fact I deleted the default "public" and created
my own: "schema_1".
In my SQL query I have to explicitly specify schema name:
"select my_colomn from schema_1.table_name;"
Can't schema be specified as default value during connection, or can I
set the schema before I send the query?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: alexander.masis@baesystems.com
Subject: Re: schema name in the SQL statement.
In-Reply-To: <738m08$3l61o@dmzms99802.na.baesystems.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox