> > It worked Thanks!! But there is definitly something wrong with the > error > message I got (right?): > > reference=# alter table "IN" add column INDESCS VARCHAR[]; > ERROR: column "indescs" of relation "IN" already exists >
I don't know, what do you see when you \d "IN" ? When you use double-quotes, capitalization is significant, So "in" and "IN" and "In" are all different tables. This error message means you already have an upper-case "IN" table and it already has a column INDESCS. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general