Re: schema name in the SQL statement.
Bosco Rama <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
Masis, Alexander (US SSA) wrote: > 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? After the connection is established, set the search_path to be your schema: "set search_path to schema_1;" At that point you can use unqualified relation references again: "select my_colomn from table_name;" Bosco. -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces