Search found 5 matches

by huelbert
29.07.2022, 20:26
Forum: ZeosLib 7.3/8.0 Forum
Topic: Change Schema in ZConnection with PostgreSQL
Replies: 8
Views: 494

Re: Change Schema in ZConnection with PostgreSQL

Could you give an example in which property I put "set search_path = MySchema"
by huelbert
28.07.2022, 13:53
Forum: ZeosLib 7.3/8.0 Forum
Topic: Change Schema in ZConnection with PostgreSQL
Replies: 8
Views: 494

Re: Change Schema in ZConnection with PostgreSQL

Good Morning I did a test putting a ZConnection and coded the properties as the code: ZConnection1.Disconnect; ZConnection1.Protocol := 'postgresql'; ZConnection1.ClientCodepage := 'UTF8'; ZConnection1.HostName := 'localhost'; ZConnection1.Port := 5432; ZConnection1.Catalog := edSchema.Text; ZConnec...
by huelbert
28.07.2022, 02:33
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Change Schema in ZConnection with PostgreSQL
Replies: 1
Views: 389

Change Schema in ZConnection with PostgreSQL

Goodnight

I'm starting a project with Zeos version 8.0.0-beta + PostgreSQL, the intention is to create several Schemas in a single database, one for each client.
In ZConnection I am not able to modify the Schema of public.

Can you help me
by huelbert
28.07.2022, 02:21
Forum: ZeosLib 7.3/8.0 Forum
Topic: Change Schema in ZConnection with PostgreSQL
Replies: 8
Views: 494

Change Schema in ZConnection with PostgreSQL

Goodnight

I'm starting a project with Zeos version 8.0.0-beta + PostgreSQL, the intention is to create several Schemas in a single database, one for each client.
In ZConnection I am not able to set the Schema.

Can you help me