I've got to insert data into a specific schema via windows based ODBC.
The program that will be inserting the data does not know about schemas, so I need to get the ODBC connection to point directly to the desired schema.
Is this possible?
Hi Mike,
In the Connect Settings textbox on the Advanced Setup dialogue for the datasource, add a statement such as:
SET search_path = my_schema, pg_catalog;
Regards, Dave.