Hi,

> I need to create a table at a stored procedure, but it fails. The sql code
> is the following:
>
> BEGIN
> CREATE TABLE 'TTEST' (
> ID INTEGER NOT NULL PRIMARY KEY,
> FIELDNAME VARCHAR(150) NOT NULL,
> FIELDVALUE INTEGER,
> DOCUMENT_ID INTEGER);
> END
>
>
> Error Message --> Token unknown CREATE
>
> How can I perform this ?

Plain and simple, you can't.

DDL statements aren't allowed in PSQL.


HTH,
Thomas.