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

ODBC doesn't gets schemas

From: El Cuy Volador <cybercuy(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC doesn't gets schemas
Date: 2007-06-16 08:11:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Dear all:

This is my first post. I am using Postgresql 8.2 and am triying to
connect from some apps (Codecharge Studio, Excel, OpenOffice Base, etc.)
to a database using a ODBC connection. The problem is that the tables do
not appear related to any schema (i.e. myschema.mytable). It just
retrieves only the plain table name (mytable) and in some cases it
appears only the tables from the public schema (for example in
OpenOffice Base). In the last case I have solved instaling an extension
 in OpenOffice, but in the other applications it is necessary to
retrieve the schema name along with the table.

┬┐Is there any configuration I am missing in the ODBC connection? or is a
features not implemented yet.

Thanks a lot and best regards,


Platform details: Windows XP SP1, Postgresql 8.2 with postgis extension.
ODBC connector:


pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2007-06-18 14:44:45
Subject: Re: ODBC doesn't gets schemas
Previous:From: Mark Cave-AylandDate: 2007-06-15 09:40:13
Subject: Re: Proposal for new pgsqlODBC feature - hiding tablesinaccessible to the current user

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