Howto Select Schema in PostgresSql
Posted: 01.05.2006, 09:49
Hi!
How can i preselect a schema for all upcoming db acess, like inserts, selects, deletes, and more..?
If i connect to std db postgres where i have a schema 'test' i can access all tables in test via 'test.tablename', bute how can i preselect 'test' as domain for all following sqls. That way i could e.g "select * from tablename" in context of 'test'.
Tx in advance,
greets Terence.
How can i preselect a schema for all upcoming db acess, like inserts, selects, deletes, and more..?
If i connect to std db postgres where i have a schema 'test' i can access all tables in test via 'test.tablename', bute how can i preselect 'test' as domain for all following sqls. That way i could e.g "select * from tablename" in context of 'test'.
Tx in advance,
greets Terence.