| 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: | Whole Thread | Raw Message | 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 |