T
T
theand12019-09-26 19:14:07
PostgreSQL
theand1, 2019-09-26 19:14:07

How to search through an array on the command line in Postgresql?

A field in the config database, it contains the following code, how to search for a specific id:
{"id": 102877}

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
postgresdev, 2019-10-10
@postgresdev

config @> '{"id":96952}'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question