Add new column

From: Rafal Kedziorski <rafcio(at)polonium(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Add new column
Date: 2005-07-20 08:49:20
Message-ID: 6.2.3.4.0.20050720104139.01e0e370@polonium.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I wan't add new column to this table:

CREATE SEQUENCE abo_product_2_user_seq;

CREATE TABLE abo_product_2_user (
abo_product_2_user_id BIGINT NOT NULL DEFAULT
NEXTVAL('abo_product_2_user_seq'),
abo_product_id SMALLINT NOT NULL,
user_id BIGINT NOT NULL,
valid_from TIMESTAMP NOT NULL,
valid_to TIMESTAMP,
debit_entry VARCHAR(12) NOT NULL,
--
PRIMARY KEY (abo_product_2_user_id),
--INDEX (abo_product_id),
--INDEX (user_id),
FOREIGN KEY (abo_product_id)
REFERENCES abo_product (abo_product_id),
FOREIGN KEY (user_id)
REFERENCES users (user_id)
);

But PostgreSQL 8.0.3 adds the new column at the end. I want add this
new column between user_id and valid_from.

Best Regards,
Rafal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dawid Kuroczko 2005-07-20 09:04:15 Re: Add new column
Previous Message Tsirkin Evgeny 2005-07-20 07:55:50 Re: can not start the postgresql, i use gentoo