[Bug] Adjusting table comments with Postgres

[expired user #9090]'s profile image [expired user #9090] posted 9 years ago in General Permalink
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';
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
ansgar's profile image ansgar posted 9 years ago Permalink
Fixed in r4981.

As I'm at it now, I'm also looking for a way to display an existing comment.

Please login to leave a reply, or register at first.