Re: [Novice] Create Table

Have you tried simply typing in something like this:

CREATE TABLE my_table (
        id              SERIAL NOT NULL PRIMARY KEY,
        column1         int,
        column2         text
);

What sort of errors are you getting?

You can see the full syntax for the create statement with a simple:

\help create table

on the command line.

Jason

"Christopher A. Goodfellow"  writes:

> 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