How to select values in Postgresql that don't match json type?

Question

I have column "ЕИУ" that's text column. Some rows contains json values, but some can be NULL on not json(text for example.) I would like to extract all values that NOT json values.

None json values example

Sample data is better presented as formatted text. See here for some tips on how to create nice looking tables. And please add some of the "non-JSON"" data that you have when you edit your question because I can't see any evidence of that in your screen shot — user330315
– user330315, Commented Feb 12, 2020 at 7:24

Arun Palanisamy · Accepted Answer · 2020-02-12 10:34:30Z

1

Looking at your sample data, you can simply get this using NOT LIKE

select * from your_table where column_name not like '{%}'

Otherwise, you can create a function that will try casting to JSON and return true or false based on that output.

select * from your_table where your_json_function(your_column);

answered Feb 12, 2020 at 10:34

Arun Palanisamy

5,4898 gold badges34 silver badges57 bronze badges

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

1 Comment

Arun Palanisamy Over a year ago

Then you can check this demo @AlexNikitin

Collectives™ on Stack Overflow

How to select values in Postgresql that don't match json type?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related