I am trying to create a database with a table.
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.
CREATE TABLE .
pgsql-novice by date
|Next:||From: Shoaib Mir||Date: 2006-10-27 17:06:36|
|Subject: Re: Create Database Question|
|Previous:||From: norman||Date: 2006-10-27 13:49:30|
|Subject: Re: Multi table insert|