Postgres JSON field

Question

I have a table

CREATE TABLE table_a
(
  id bigint NOT NULL,
  name json,
  CONSTRAINT table_a_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE table_a
  OWNER TO postgres;

Data in the table:

1;"{"ru":"Название","en":"Name"}"
2;"{"ru":"Название","en":"Name"}"

When I trying select the name

SELECT id, name->'en'::text as name from table_a;

have next results:

1;""Name""
2;""Name""

How I can select data without quotes?

Thanks!

Ihor Romanchenko · Accepted Answer · 2013-12-06 17:16:54Z

4

The -> operator returns JSON. Try using ->> operator - it returns varchar. Something like:

SELECT id, name->>'en'::text as name from table_a;

answered Dec 6, 2013 at 17:16

Ihor Romanchenko

29k9 gold badges56 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres JSON field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related