Add new column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux