i create table with comment,but i can't see comment in heidisql
Revision 9.4.0.5146
i create table with comment,but i can't see comment in heidisql
Revision 9.4.0.5146
Yes, I have the same problem on rev 9.4.0.5173(64bit). When you look in Create code tab I see:
... COMMENT ON COLUMN "res_country_state"."code" IS E''; ...
In this example, [E''] is supposed to be ['State Code']
If I open this table with pgAdminIII, I can see the comment
Thanks
This is issue #62. I am going to check the cause of it.
I just refactored the string escaping logic for Postgres mode, so this should be fixed.
Instead, HeidiSQL now escapes less than before, as follows:
LIKE
strings:%
=> \%
_
=> \_
For these 2 backslash usages, PostgreSQL does not seem to require that E
prefix.
See it in action here:
And please shout if the above logic is wrong for some reason.
Thank you very much for so fast reaction. Now the result looks much better. But some comments are still invisible. The problem can be connected with datatype timestamp. All comments on these lines (timestamp datatype) are still invisible. I tested this theory in this example:
Result:
See the documentation for date/time types: https://www.postgresql.org/docs/current/datatype-datetime.html
Issue #62: distinct between TIMEZONE (without time zone) and TIMEZONETZ (with time zone). And modify GetDatatypeByName() so it deletes the longest detected datatype string PostgreSQLDatatypes.Names . This solves empty/undetected column comments in ParseTableStructure(). See https://www.heidisql.com/forum.php?t=23211#p34709
Should also be fixed in the next build.
Please post in ticket #62 for further stuff.
Please login to leave a reply, or register at first.