Does Zeos support Postgres schemas?

[vfclists]

Does  Zeos support Postgres schemas?

It looks like the Catalog property of TZeosConnection is suppposed to be what the Postgres schema is set to but it doesn't seem to work.

The only other place where the schema can be set seems to be in the Properties property.

In case it does is there a syntax for this?

[paweld]

https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=165327

[vfclists]

I have viewed https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=165327 earlier and it seems no-one is picking it up.

The PQConnection of the SQLDB components supports it via

options='-c search_path=lazlib_01'

in the Params property, so I suspect the URL generated for the Zeos connection does not support the options parameter anywhere in its properties.

Perhaps ZURL needs some updating.

I need to have a talk with the Zeos developers. It doesn't seem to be too difficult an issue

[Thaddy]

I still have no clue why people want to use Zeos? especially with PostgreSQL. I don't get Zeos. Probably because I don't need it.

[vfclists]

I still have no clue why people want to use Zeos? especially with PostgreSQL. I don't get Zeos. Probably because I don't need it.

Because you've got a lot of code and libraries that would take too long to convert to other libraries?

Also works on Delphi?

[Thaddy]

Delphi and Freepascal work perfectly fine without Zeos.
I really do not get Zeos.

[Hansvb]

I still have no clue why people want to use Zeos?

There is one thing that zeos can do and standard lazarus components can't. That's a select* query on an Oracle spatial table and then show the data in a data grid. With a zeos query component combined with a laz datasource and datagrid it works, with a lazarus query component, datasource and datagrid you get an error. (the geometry column is the problem)  That's for me the only reason to use zeos.

Edit: zeos from trunc. The stable version doesn’t like oracle geometry either.