schema name in the SQL statement.

From: "Masis, Alexander \(US SSA\)" <alexander(dot)masis(at)baesystems(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: schema name in the SQL statement.
Date: 2008-08-19 22:43:27
Message-ID: 738m08$3l61o@dmzms99802.na.baesystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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?

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Masis, Alexander (US SSA) 2008-08-19 22:47:56 Where can I get the LIBPQ++
Previous Message Michael Meskes 2008-08-19 10:31:18 Re: ecpg 'set' failure using host vars