ESQL CREATE DATABASE

Hello,

I am using embedded SQL command for creating the database:

EXEC SQL BEGIN DECLARE SECTION;
char dbase[32];
EXEC SQL END DECLARE SECTION;
...

EXEC SQL CONNECT TO postgres;
//the create database cannot be run in transaction block
EXEC SQL SET AUTOCOMMIT TO ON;

EXEC SQL CREATE DATABASE :dbase;

I get an error during compile with ecpg (/usr/bin/ecpg -I../../include
-c source_file.ec)
ERROR: syntax error at or near ":dbase"
*** Error code 3

When I use literal string like: "EXEC SQL CREATE DATABASE my_dbase;" it
is compilable and it works.

All other SQL commands work with the variables except for the CREATE
DATABASE.

I am using the package postgresql-devel-8.1.3-12.


Any idea?

Thank you!

Pavel Krejci