Delete a column postgres said it don't exist

Asked Feb 04 '19 at 18:52

Active Feb 04 '19 at 18:52

Viewed 51 times

In a table I have this field

prepared boolean NOT NULL,

I try to drop column and do

alter table lcm.bnq
    drop column prepared,
    drop column put_freezer;

I get this mesage

ERROR: column "prepared" of relation "bnq" does not exist

I see column in the table.

I tried

alter table lcm.bnq_durabilities
    drop column "prepared",
    drop column put_freezer;

Get same result

Any Idea?

asked Feb 04 '19 at 18:52

robert trudel

do you have pgAdmin? You can delete a column there and check the generated sql query – Juan Carlos Oropeza Feb 04 '19 at 19:00
2

most like it you have different table, different schema or different field name , check here to see how describe a table https://stackoverflow.com/questions/109325/postgresql-describe-table – Juan Carlos Oropeza Feb 04 '19 at 19:02
1

the table is `bnq` or `bnq_durabilities` – Juan Carlos Oropeza Feb 04 '19 at 19:03
Post the result of `\d table_name` in `psql`. – Laurenz Albe Feb 05 '19 at 07:25

0 Answers0