Postgres Pro
Downloads
Home   >   mailing lists

Thread: [Novice] Create Table

[Novice] Create Table

From
"Christopher A. Goodfellow"
Date:
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?

Re: [Novice] Create Table

From
Jason Earl
Date:
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

Re: [Novice] Create Table

From
"Josh Berkus"
Date:
Christopher,

>   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?

Yes.  Bruce Momjian's book, "PostgreSQL: Introduction and Concepts" has
 an excellent brief tutorial for the beginner.  It is available from
 online bookstores in several languages.

-Josh

Re: [Novice] Create Table

From
Jeff Self
Date:
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