From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "Pavel SRB" <srb(at)heckler-koch(dot)cz> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: alter table |
Date: | 2008-04-07 21:08:19 |
Message-ID: | 264855a00804071408s335a4e33ifd8bbebf40de1047@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, Apr 7, 2008 at 4:53 PM, Pavel SRB <srb(at)heckler-koch(dot)cz> wrote:
> hi all
>
> please i have one question. I made table called tab_article with
>
> CREATE TABLE "tab_article" (
> "id" serial NOT NULL PRIMARY KEY,
> "flag" boolean NOT NULL,
> "title" text NOT NULL,
> "journal" integer NOT NULL,
> "doi" varchar(255) NOT NULL,
> "year" integer NOT NULL,
> "volume" integer NOT NULL,
> "issue" integer NOT NULL,
> "pages_start" integer NOT NULL,
> "pages_end" integer NOT NULL,
> "printed" boolean NOT NULL,
> "public" boolean NOT NULL,
> "entry" boolean NOT NULL,
> "filename" integer NOT NULL,
> "language" integer NOT NULL,
> "link" integer NOT NULL,
> "info" varchar(255) NOT NULL
> );
>
> and later another table called tab_journal
>
> CREATE TABLE "tab_journal" (
> "id" serial NOT NULL PRIMARY KEY,
> "flag" boolean NOT NULL,
> "name" text NOT NULL,
> "publisher" integer NOT NULL,
> "issn_print" integer NOT NULL,
> "issn_online" integer NOT NULL,
> "link" integer NOT NULL,
> "date_range" varchar(255) NOT NULL
> );
>
> and i needed to change column journal in tab_article to be set like
> "journal_id" integer NOT NULL REFERENCES "article_journal" ("id")
>
> and i am not able to find the right alter table command.
> thank you very much
You will want to add the NOT NULL as one statement. Then, add the
foreign key constraint as a second statement. There are examples of
how to do each here:
http://www.postgresql.org/docs/8.3/static/sql-altertable.html
Hope that helps.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel SRB | 2008-04-07 21:18:38 | Re: alter table |
Previous Message | Pavel SRB | 2008-04-07 20:53:20 | alter table |