Create Database Question

["Greg Quinn" <greg(at)officium(dot)co(dot)za>]

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 …