Trouble Accessing Schema-Qualified Table
| От | Jerry Richards |
|---|---|
| Тема | Trouble Accessing Schema-Qualified Table |
| Дата | |
| Msg-id | 2BF7FB90DF25EA4485949F3AF2B9D69603EB7F73B6@VA3DIAXVS351.RED001.local обсуждение исходный текст |
| Ответы |
Re: Trouble Accessing Schema-Qualified Table
|
| Список | 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
В списке pgsql-general по дате отправления: