Re: Create Database Question

You have to create the database first and then run your newdb.sql

# createdb -U dbuser dbname
CREATE DATABASE
# psql –U dbuser dbname < newdb.sql

Norman

Greg Quinn <greg(at)officium(dot)co(dot)za> wrote: I am trying to create a database with a table…

i.e

create database myNewDb;

CREATE TABLE servers (
serverid character varying(60) NOT NULL,
companyid character varying(60) NOT NULL,
servername character varying(50) NOT NULL,
companyname character varying(50) NOT NULL
) WITHOUT OIDS;

Cool. The problem is, if I run this SQL command, from within another database instance, it tries to create the table for that database, and not for the myNewDb database.
How do I modify the query.

I know SQL Server has something like…

Using [myNewDb]

CREATE TABLE …

Send instant messages to your online friends http://uk.messenger.yahoo.com