Re: [Novice] Create Table - Mailing list pgsql-novice

From Jason Earl
Subject Re: [Novice] Create Table
Date
Msg-id 87heoogdxq.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to [Novice] Create Table  ("Christopher A. Goodfellow" <cgoodfellow@tealuxe.com>)
List pgsql-novice
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@tealuxe.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@postgresql.org so that your
> message can get through to the mailing list cleanly

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: how to INSERT foreign keys?
Next
From: "Josh Berkus"
Date:
Subject: Re: [Novice] Create Table