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

Re: Can I specify a SCHEMA in the ODBC string?

From: Ludek Finstrle <ludek(dot)finstrle(at)pzkagis(dot)cz>
To: Jon Farb <sawzall710(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Can I specify a SCHEMA in the ODBC string?
Date: 2005-06-16 09:28:49
Message-ID: 20050616092849.GA3957@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> Does anyone have a solution to the below archived message?  I'm
> running into the same issue.

set search_path = ...

It's well described in postgresql doc.

Luf

> I'd like to export a table from MS Access to PostgreSQL. By default,
> it puts it in the public schema, but I'd like to specify an alternate
> one.
> Is this possible? If so, what's the syntax? Is the syntax for ODBC
> connection strings documented anywhere? I've googled for this info,
> but unsuccessfully.

In response to

pgsql-odbc by date

Next:From: vladimirDate: 2005-06-17 12:47:35
Subject: Re: Can I specify a SCHEMA in the ODBC string?
Previous:From: Michael KochetkovDate: 2005-06-15 16:38:35
Subject: {? = call myfunc(?,?)} syntax for set-returning functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group