postgres support of 9.4
Does HeidiSQl support new types such as json , hstore ? in Pg (9.4)
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';
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';
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 ?
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
Please login to leave a reply, or register at first.