Creating Database from App using Zeos

sandeep_c24 · Post by **sandeep_c24** » 01.12.2007, 08:18

Is it possible to create a new Postgres database from my app using Zeos? If it is possible could someone give an example.

Regards

Sandeep

skaw · Post by **skaw** » 03.12.2007, 18:31

Something like this...

auxZSQLProcessor := TZSQLProcessor.Create(Connection);
auxZSQLProcessor.Connection := Connection;
auxZSQLProcessor.Script.Text := 'CREATE DATABASE dbname WITH TEMPLATE = template0 ENCODING = ''UTF8'';';
auxZSQLProcessor.Execute;

First of all you must create a connection with the default postgres database.

Best regards
skaw

sandeep_c24 · Post by **sandeep_c24** » 04.12.2007, 07:01

Thanks skaw. That worked.

Regards

Sandeep