Postgres Sql : Alter table

Question

I am fetching all the records from the Excel sheet and adding columns into the database according to the Excel header row. After fetching I alter the table and adding columns into the newly created table and it works perfectly fine. but when I add one more column into the excel file and running the query again it supposed to add the column which I have created in the excel file but instead, it gives me an error of Column already exists The query which I m running is

"ALTER TABLE " + name + " ADD " + cellValue + " varchar(5000)"

Thanks in advance..

Philippe · Accepted Answer · 2021-06-25 07:39:56Z

2

If you want to create only columns that don't exist write your query like this

"ALTER TABLE " + name + " ADD if not exists " + cellValue + " varchar(5000)"

answered Jun 25, 2021 at 7:39

Philippe

1,8376 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres Sql : Alter table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related