From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: OOO and postgres |
Date: | 2011-01-07 17:56:03 |
Message-ID: | alpine.LNX.2.00.1101070949490.2506@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 7 Jan 2011, Bernhard Rohrer wrote:
> CREATE TABLE "Bladetypes"
> (
> "ID" integer NOT NULL,
> "type" character varying[] NOT NULL,
> CONSTRAINT "Bladetypes_pkey" PRIMARY KEY ("ID")
> )
>
> ALTER TABLE "Bladetypes" ADD COLUMN "ID" integer;
> ALTER TABLE "Bladetypes" ALTER COLUMN "ID" SET NOT NULL;
>
> ALTER TABLE "Bladetypes" ADD COLUMN "type" character varying[];
> ALTER TABLE "Bladetypes" ALTER COLUMN "type" SET NOT NULL;
Don't use double quotes in your create table stanza. You can use them on
the table name with alter table and insert into.
The data type is VARCHAR(), not character varying[].
Why are you altering the table to be exactly how you defined it?
Use single quotes to define text strings in your values statements.
Perhaps you'll find value in reading a book on SQL. Rick van der Lans and
Joe Celko both write outstanding books on the language and its use.
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Susan Cassidy | 2011-01-07 18:01:04 | Re: OOO and postgres |
Previous Message | Adrian Klaver | 2011-01-07 17:53:01 | Re: OOO and postgres |