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@officium.co.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