Hello,
I need to create a PostgreSQL database from my application. The
TPQConnection.CreateDB works fine, but I need to configure some properties
of my database in your creation.
In pgAdmin, I execute:
CREATE DATABASE myuser
WITH ENCODING='UTF8'
OWNER=myowner
TEMPLATE=template1
LC_CTYPE='Portuguese_Brazil.1252'
CONNECTION LIMIT=-1
TABLESPACE=pg_default;
But, how to create a database with TPQConnection passing the ENCODING,
OWNER, TEMPLATE, LC_CTYPE and TABLESPACE properties?
Thank you!
ps. I tried ExecuteDirect, but: "CREATE DATABASE cannot be executed inside
a transaction block".
--
Silvio Clécio
My public projects - github.com/silvioprog
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
