Rename and add column in same query in PostgreSQL

Question

Let's say I have a table Student with just 2 columns - id bigint, name varchar(50).

I'm trying to rename it and add column in a same single query in PostgreSQL version 11.16 like below:

ALTER TABLE student
  RENAME COLUMN name TO fullname, 
  ADD COLUMN roll_no varchar(30);

But I got this error:

Syntax error at or near "ADD"

Is it possible? If not, why?

No, not possible. You could execute two ALTER statements in a single transaction. And why it's not supported? Because nobody has build it yet. — Frank Heikens
– Frank Heikens, Commented Oct 18, 2022 at 11:06
im not sure but maybe that will help you: stackoverflow.com/questions/70176036/… — Marco
– Marco, Commented Oct 18, 2022 at 11:09
@frank-heikens, But I can add two columns in a single alter query. — Md. Nowshad Hasan
– Md. Nowshad Hasan, Commented Oct 18, 2022 at 11:12
@Md.NowshadHasan: Yes, that's correct, you can add multiple columns in a single statement. But not rename and add in a single statement. Just check the manual — Frank Heikens
– Frank Heikens, Commented Oct 18, 2022 at 11:13

Md. Nowshad Hasan · Accepted Answer · 2022-10-18 11:56:25Z

0

Actually, that is not possible. I got this from the StackOverflow answer. One RENAME is possible for only one statement. Even multiple RENAME commands are also not possible. Here is the postgres manual.

answered Oct 18, 2022 at 11:56

Md. Nowshad Hasan

6264 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Rename and add column in same query in PostgreSQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related