Sample Header Ad - 728x90

Postgresql explain alter table add column doesn't work

2 votes
2 answers
2737 views
I'm using Postgresql 12 (AWS RDS) and pgAdmin4. While the following statement works
select * from table "Commands";
The next one
alter table "Commands" drop column "test";
gives this error
:  syntax error at or near "alter"
LINE 1: explain alter table "Commands" drop column "test";
                ^
SQL state: 42601
Character: 9
I made sure the statement alter table "Commands" drop column "test" itself can be run successfully so this cannot be an issue with that statement. Does explain not work with alter or am I missing anything?
Asked by Tran Triet (123 rep)
Sep 16, 2021, 10:05 AM
Last activity: Jun 20, 2025, 11:01 AM