Windows 10
PB Version 6.5.1
Postgres 9.2
psql-ODBC 9.02.01 Connection
Hi,
When I connect to postgres database with PB and create a Datawindow, the schema will be automatically generated before the table name.
I found that when I created a new Datawindow, the schema was already in it.
I tried to set PBCatalogOwner, but the Datawindow still has a schema.
When I delete the schema manually, the DBname in ROWS -> ColumnSpecifications will have no table name.
I can manually set search_path in the database or odbc to specify it. Why is the schema automatically added in PB?
How can I make PB not generate schema, modify PB settings or ODBC configuration, Or in other ways?
Thanks!