Creating Database from App using Zeos
Posted: 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
Regards
Sandeep
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