Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Setting search_path in ODBC connection string


  • From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
  • To: "Andrus" <kobruleht2(at)hot(dot)ee>
  • Cc: <pgsql-odbc(at)postgresql(dot)org>
  • Subject: Re: Setting search_path in ODBC connection string
  • Date: Thu, 6 Nov 2008 00:34:19 +0900
  • Message-id: <E0CE7E8BCD904FDE90D40E0512AF1F93@HIRO57887DE653> <text/plain>

Please set in odbc.ini.

ConnSettings    = set search_path = Others,public;

Regards,
Hiroshi Saito

----- Original Message ----- From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Wednesday, November 05, 2008 11:24 PM
Subject: [ODBC] Setting search_path in ODBC connection string


How to set default search_path in connection string ?

I have tables in non-public schema and need to set this to allow ODBC application to find tables without using schema prefix.

Andrus.

--
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group