From: | Jerry Richards <jerry(dot)richards(at)teotech(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Trouble Accessing Schema-Qualified Table |
Date: | 2010-11-15 16:35:13 |
Message-ID: | 2BF7FB90DF25EA4485949F3AF2B9D69603EB7F73B6@VA3DIAXVS351.RED001.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I need to access a database using two different schemas. During initialization the default schema is set as follows:
set schema 'ucm';
Then later, I need to get data from a table in another schema 'ts_sofia_internal', so I tried the following, but it returns an error as shown:
teo=# select * from sip_presence('ts_sofia_internal') where sip_presence.sip_user='1003';
ERROR: function sip_presence(unknown) does not exist
LINE 1: select * from sip_presence('ts_sofia_internal') where sip_pr...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
teo=#
Does anyone know how I can do this? By the way, I'm using odbc to connect to the database.
Thanks,
Jerry
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2010-11-15 16:37:31 | Re: identifying local connections |
Previous Message | Tom Lane | 2010-11-15 16:24:18 | Re: identifying local connections |