Re: ODBC doesn't gets schemas - Mailing list pgsql-odbc

From Richard Broersma Jr
Subject Re: ODBC doesn't gets schemas
Date
Msg-id 208257.85947.qm@web31813.mail.mud.yahoo.com
Whole thread Raw
In response to ODBC doesn't gets schemas  (El Cuy Volador <cybercuy@gmail.com>)
Responses Re: ODBC doesn't gets schemas
List pgsql-odbc
--- El Cuy Volador <cybercuy@gmail.com> wrote:

> 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).

I am not sure I completely understand your problem,  but my experiece is that schema name are
recognized by the ODBC driver.  However, in my case I use MS Access, when I use ODBC to link table
from the PostgreSQL server the resolved schema.table names in Access are "schema_table".

I am not sure what Open Office does in this regard.

Regards,
Richard Broersma Jr.

pgsql-odbc by date:

Previous
From: El Cuy Volador
Date:
Subject: ODBC doesn't gets schemas
Next
From: Richard Wesley
Date:
Subject: Re: ODBC doesn't gets schemas