Re: [gnome-db] gda and PostgreSQL schemas

[Vivien Malerba <vmalerba gmail com>]

On 7/28/05, Diego Zuccato <diego otello alma unibo it> wrote:
> Hello all.
> 
> It seems that Mergeant can't retrieve tables in PG's schemas.
> If you do something like:
> 
> CREATE SCHEMA x;
> CREATE SCHEMA y;
> CREATE TABLE x.a (...);
> CREATE TABLE y.a (...);
> CREATE TABLE b (...);
> 
> the only table Mergeant can "see" is b.
> 
> Is it a known limitation (couldn't find it documented anywhere) or
> something that sneaked in unnoticed?
> 
> Please cc me since I'm not subscribed to this list.
> 

You have to define the search_path you want to use in the connection's
DSN string, and if you don't then the 'public' schema is assumed (this
is why table b is visible).

Regards,

Vivien