- jeff hersey
- PowerBuilder
- Thursday, 20 September 2018 06:17 PM UTC
Windows 10
PB 2017 R3
Postgresql 9.6
ODBC Connection
-----
Hi,
When connecting to Postgresql, table names are not schema qualified. PB assumes the user that I am connecting with, is the schema / owner of all tables.
I have confirmed this by connecting with various postgresql user logins, and each time, PB will use the current user as the schema / table owner.
How can we get PB to schema qualify names.
Thanks!
Note:
We have been using PB (10, 11,12.5) with Postgresql for 10 yrs
There are tables in two or more schemas with same name - dev is the logged in user. There is no dev schema.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.