Re: Create Database Question

["Shoaib Mir" <shoaibmir(at)gmail(dot)com>]

After create database add something like:

\c myNewDb

Thanks,
--------
Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)

On 10/27/06, 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 …