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" <cgoodfellow(at)tealuxe(dot)com> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly