Re: JSON

Hi Dave,

What is the array datatype for that particular column in which you are
getting `[object Object]`, Is it json[ ] or jsonb[ ]?

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Sep 19, 2016 at 8:22 PM, Dave Barter <dave(at)phased(dot)co(dot)uk> wrote:

> I’ve recreated it again
>
> See attached screenshot
>
>
>
> For info the JSON for id 6343 is [{"name":"people_and_
> property","app_id":37}]
>
> Field 8256 is [“whole..”,”.. ….]
>
> I have conformed the issue exists with another field that is of type [{ …}]
>
> It appears to be an issue with arrays
>
> Dave Barter
> dave(at)phased(dot)co(dot)uk
> @citizenfishy
> www.phased.co.uk
>
> On 19 Sep 2016, at 14:51, Murtuza Zabuawala <murtuza.zabuawala@
> enterprisedb.com> wrote:
>
> Hi,
>
> I tried many times opening/closing grid with table definition & sample
> data given by Dave but without inherits option but no luck in re-producing
> the issue on my side.
>
> Regards,
> Murtuza
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Mon, Sep 19, 2016 at 6:26 PM, Dave Barter <dave(at)phased(dot)co(dot)uk> wrote:
>
>> Interestingly shutting down and restarting PGAdmin and the issue has gone
>> away. I will try and recreate again.
>>
>> If it makes a difference the table was inherited
>>
>> CREATE TABLE ng_customer.files
>> (
>> file_id integer,
>> file_name text,
>> file_path text,
>> file_attributes json,
>> record_count integer,
>> status character,
>> date_uploaded timestamp without time zone,
>> CONSTRAINT files_pkey PRIMARY KEY (file_id)
>> )
>> INHERITS (ng_toplevel.files)
>> WITH (
>> OIDS = FALSE
>> )
>>
>>
>> Dave Barter
>> dave(at)phased(dot)co(dot)uk
>> @citizenfishy
>> www.phased.co.uk
>>
>> On 19 Sep 2016, at 13:41, Murtuza Zabuawala <
>> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>
>> Hi Dave,
>>
>> I am able to see the json data properly in with *pgadmin4-1.0-rc1.dmg* file
>> on my mac machine,
>> Please find screenshot attached.
>>
>>
>> @Dave Barter,
>> Could you please share screenshot or your table definition, so that I can
>> re-produce the issue?
>>
>>
>> Regards,
>> Murtuza
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> On Mon, Sep 19, 2016 at 5:37 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>> OK, thanks.
>>>
>>> On Mon, Sep 19, 2016 at 1:06 PM, Murtuza Zabuawala
>>> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>> > Hi Dave,
>>> >
>>> > I was aware of that issue and that's why I also tested SlickGrid JSON
>>> > support(in browsers) when I integrated it :)
>>> > Seems like issue with runtime's webkit, let me check & confirm.
>>> >
>>> > --
>>> > Regards,
>>> > Murtuza Zabuawala
>>> > EnterpriseDB: http://www.enterprisedb.com
>>> > The Enterprise PostgreSQL Company
>>> >
>>> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>> >>
>>> >> Murtuza,
>>> >>
>>> >> On Mon, Sep 19, 2016 at 12:22 PM, Dave Barter <dave(at)phased(dot)co(dot)uk>
>>> wrote:
>>> >> > Apologies if I have missed this elsewhere
>>> >> >
>>> >> > JSON columns in tables are appearing as [Object object] when viewing
>>> >> > data so you cannot edit or view json as you used to be able to do
>>> in
>>> >> > pagadmin3
>>> >> >
>>> >> > I am using pgadmin 4 1.0-rc1 on Mac OSX
>>> >> >
>>> >> > Is this by design or a bug?
>>> >>
>>> >> Is this a regression following https://redmine.postgresql.org
>>> /issues/1404?
>>> >>
>>> >> --
>>> >> Dave Page
>>> >> Blog: http://pgsnake.blogspot.com
>>> >> Twitter: @pgsnake
>>> >>
>>> >> EnterpriseDB UK: http://www.enterprisedb.com
>>> >> The Enterprise PostgreSQL Company
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>> <JSON_data-min.jpg>
>>
>>
>>
>
>