HeidiSQL uses MySQL syntax:
ALTER TABLE "admintable" COMMENT=E'Authentication for administrative accounts';
Which fails, where it should be:
COMMENT ON TABLE "admintable" IS E'Authentication for administrative accounts';
[Bug] Adjusting table comments with Postgres
Code modification/commit
from ansgarbecker,
9 years ago,
revision 9.2.0.4981
PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment. See http://www.heidisql.com/forum.php?t=18937
Please login to leave a reply, or register at first.