Create database, tables etc in one script postgresql

Question

I've a script:

CREATE DATABASE ahop

GO

CREATE TABLE shop.dbo.TABLE1 ( 
); 

CREATE TABLE shop.dbo.TABLEN ( 
);

But it doesn't seem to work in PostgreSQL. Error message: "error near GO". I dont get it, how to create scripts in Postgresql?

When i remove "GO" and replace it by ";" I've got an error. Message: "CREATE DATABASE cannot be executed from a function or multi-command string". And the issue is, that i need to execute them all from one script. — Noran, Nov 25 '12 at 16:12
You also can't specify a table with database.schema.tablename. But this all documented in the manual. — a_horse_with_no_name, Nov 25 '12 at 16:18

今草顿 웃 · Accepted Answer · 2012-11-25 16:16:20Z

up vote 2 down vote accepted

Replace the T-SQL batch terminator GO with the PostgreSQL batch terminator ;.
GO is not supported in postgreSQL

you need to connect on the database using \. eg,

 CREATE DATABASE testdatabase; 
 \c testdatabase 
 CREATE TABLE testtable (testcolumn int);

answered Nov 25 '12 at 16:07

今草顿 웃
121k1791173

Please take a look on my comment to main post. – Noran Nov 25 '12 at 16:14

see my updated answer. – 今草顿 웃 Nov 25 '12 at 16:16

1 Answer