ALTER TABLE for field modify...

From: MG <makgab(at)freemail(dot)hu>
To: PostgreSQL List <pgsql-admin(at)postgresql(dot)org>
Subject: ALTER TABLE for field modify...
Date: 2002-05-02 20:27:31
Message-ID: XFMail.20020502222731.makgab@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi!

How can I modify a field of table with ALTER TABLE? I want to modify the
constraint. The TABLE is now:
"ID" int8 NOT NULL, UNIQUE

But I want this:
"ID" int8 REFERENCE "table2"

THanx!
Bye!
-----------------
Linux RedHat 7.1
-----------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aaron Spiteri 2002-05-02 23:02:23 Fast CGI
Previous Message Stephan Szabo 2002-05-02 17:12:23 Re: ALTER TABLE hangs