Trouble Accessing Schema-Qualified Table

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

Responses

Browse pgsql-general by date

  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