Start a new topic

Support of PostgreSql json format

[This topic is migrated from our old forums. The original author name has been removed]

Since version 9.2, Postgres support a new data type: json. And the upcoming version 9.4 will all the jsonb (binary) format. It will be nice if Dbvis can support those type directly. With the current version, we need to typecast to text avery time in request to be able to work with it. http://www.postgresql.org/docs/9.3/static/datatype-json.html http://www.postgresql.org/docs/9.4/static/datatype-json.html Edited by: Thierry Leveque on Nov 17, 2014 4:11 PM

[This reply is migrated from our old forums.]

Re: Support of PostgreSql json format
Hi Thierry, Thanks for the suggestion. We have an open ticket for adding support for JSON column value editing in a grid, i.e. the Data tab or a result set tab. Is that what you are asking for, or did you have something else in mind? Best Regards, Hans
[This reply is migrated from our old forums.]

Re: Support of PostgreSql json format
Thierry, The just released 92.2329 beta version now have support for the JSON, HSTORE and, JSONB data types for PostgreSQL. You may download and give it a try here: http://www.dbvis.com/download/beta/ The beta versions will be publicly available as DbVisualizer 9.2 during December. Regards Roger
[This reply is migrated from our old forums.]

Re: Support of PostgreSql json format
Thierry, DbVisualizer 9.2 has just been released with support for HSTORE, JSON and JSONB types in PostgreSQL. http://www.dbvis.com/doc/relnotes/?version=9.2&showtoc=false Regards Roger