Does TZConnection respect the schema settings of PostgreSQL?
lazarus / 16-Databases

----------------------------------------------------------------------
vfclists · 2016-02-24 00:44

I am using the TZConnection from Zeoslib and although I set the schema
in the connection, when I run a query it seems to revert to the PUBLIC
schema. Unless I prefix tablenames with the schema name like Code:
Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i select
schemaname.tablename from schema the queries don't work

Are schemas properly supported by Zeoslib?

----------------------------------------------------------------------
tintinux · 2016-03-16 13:28

Yes,  schema are supported, at least this way :

Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
fieldname FROM schemaname.tablename.
Regards