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 .