Runtime database create

[Shomer]

Hi there! I am new here and new to Zeos. I am trying to issue such statment but I even can imagine how:

CREATE DATABASE "dd01" WITH OWNER = "postgres" ENCODING = 'latin1' TABLESPACE = "pg_default" LOCATION = 'c:\teste' TEMPLATE = "postgres";

On that example, dd01 would be a parameterized name, also the location. How I can create a database programmatically? With Firebird it was a very easy function. What Zeos components I should use? I am working with the 6.5.1 alpha-version.

Thank you!

Magno

[zippo]

What's the error?

[btrewern]

I'd use a TZQuery and just ExecSQL the query. I doubt you can use parameters to create this type of query so just create the above string and use that.

Ben.

[Shomer]

Solved! I use ZProcessor with something such:

Add('CREATE DATABASE "'+myDatabaseName+'" WITH ENCODING = ''latin1'' TABLESPACE = "pg_default"; ');

Works fine!