[GENERAL] What is wrong here?

The following function returns this error: pg_query(): Query failed: ERROR: permission denied for relation customers CONTEXT: PL/pgSQL function "newprofile" line 8 at SQL statement What is wrong here? CREATE SEQUENCE CustomerID; CREATE TABLE Customers ( CustomerID INTEGER NOT NULL DEFAULT n

[GENERAL] Executing script file

Hi! I cannot imagine how to create db from a script file and execute other DDL statements on this new db. Currently I use 'psql -f file' to perform all needed DDL statements except of create db. Because when I insert 'CREATE DATABASE' at the beginning of the script, the server creates a db but foll