Create Database Question

From: "Greg Quinn" <greg(at)officium(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Create Database Question
Date: 2006-10-27 16:38:24
Message-ID: 001401c6f9e6$528eea90$6501a8c0@melt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 .

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Shoaib Mir 2006-10-27 17:06:36 Re: Create Database Question
Previous Message norman 2006-10-27 13:49:30 Re: Multi table insert