postgres support of 9.4

[expired user #8685]'s profile image [expired user #8685] posted 9 years ago in General Permalink
Does HeidiSQl support new types such as json , hstore ? in Pg (9.4)
ansgar's profile image ansgar posted 9 years ago Permalink
Not with an appropriate grid editor, and probably not even in the table designer. But I can add data types when you point me to their documentation page, so you can at least handle such tables in the table designer.
[expired user #8685]'s profile image [expired user #8685] posted 9 years ago Permalink
Ok .
json : http://www.postgresql.org/docs/9.4/static/datatype-json.html
hstore : http://www.postgresql.org/docs/9.4/static/hstore.html

this is error i get the log :
SELECT *, pg_table_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME)) AS data_length, pg_relation_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME)) AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_namespace" n ON t.table_schema = n.nspname LEFT JOIN "pg_class" c ON n.oid = c.relnamespace AND c.relname=t.table_name WHERE t."table_schema"='public';
/* Unknown datatype oid #1034 for "nspacl". Fall back to UNKNOWN. */
/* Unknown datatype oid #1034 for "relacl". Fall back to UNKNOWN. */
/* Unknown datatype oid #1009 for "reloptions". Fall back to UNKNOWN. */
SELECT "p"."proname" FROM "pg_catalog"."pg_namespace" AS "n" JOIN "pg_catalog"."pg_proc" AS "p" ON "p"."pronamespace" = "n"."oid" WHERE "n"."nspname"='public';
ansgar's profile image ansgar posted 9 years ago Permalink
So, are these columns nspacl, relacl and reloptions actually from such a jdon or hstore data type?
[expired user #8685]'s profile image [expired user #8685] posted 9 years ago Permalink
sorry for the last repsonse .
nspcal, relacl etc.. come pg_namespace (http://www.postgresql.org/docs/9.4/static/catalog-pg-namespace.html) see here from details . I think they are more related to roles and privilages .

here is what i get from create simple table :
create table a ( b json, c int);

select column_name,data_type from columns where table_name='a' ;

column_name;data_type
c;integer
b;json

I think the problem is in the datatype json , can you display it as string (text ) for start ?





Code modification/commit from ansgar.becker, 9 years ago, revision 4904
Support JSON data type on PostgreSQL. See http://www.heidisql.com/forum.php?t=17584
ansgar's profile image ansgar posted 9 years ago Permalink
r4904 adds basic support for that json data type. However, not sure if that works with all kinds of values in the grid. I could insert a simple test string in a json column.
[expired user #8685]'s profile image [expired user #8685] posted 9 years ago Permalink
it works . great .

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