Re: [Novice] Create Table

You need to be in the database that you want to create a table. Example:

psql testdb    <--- This puts you in the testdb database

testdb=#    <--- You should see this now
From here, you can create the table as below:

testdb=# create table test
( testid SERIAL PRIMARY KEY,
  testname VARCHAR(20) NOT NULL DEFAULT '',
  testdate DATE,
  quantity INTEGER,
  amount NUMERIC(8,2)
);

This will create a table. Standard SQL syntax. Try to pick up Bruce
Momjian's book 'PostgreSQL Introduction and Concepts'

On Mon, 2002-02-11 at 11:24, Christopher A. Goodfellow wrote:
> Hello All,
>
>   I am a real novice to postgresql and am having trouble creating a new
> table in my existing database through the psql monitor.
>
>   I have read the programmers guide, the create table syntax, and searched
> for some examples but with no luck.  Are there any good examples of step by
> step how to create a new table?
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930