postgresql list and order tables by size
How can I list all the tables of a PostgreSQL database and order them by size? 12 Answers 12
postgresql-9.3
Check if a Postgres JSON array contains a string
I have a table to store information about my rabbits. It looks like this: create table rabbits (rabbit_id bigserial primary key, info json … Read more
Allow docker container to connect to a local/host postgres database
I’ve recently been playing around with Docker and QGIS and have installed a container following the instructions in this tutorial. Everything works great, … Read more
How do I query using fields inside the new PostgreSQL JSON datatype?
I am looking for some docs and/or examples for the new JSON functions in PostgreSQL 9.2. Specifically, given a series of JSON records: … Read more
How do I modify fields inside the new PostgreSQL JSON datatype?
With postgresql 9.3 I can SELECT specific fields of a JSON data type, but how do you modify them using UPDATE? I can’t … Read more