for PostgreSQL questions specific to version 9.3.
With postgresql 9.3 I can SELECT specific fields of a JSON data type, but how do you modify them using UPDATE? …
json postgresql postgresql-9.3 postgresql-jsonI am looking for some docs and/or examples for the new JSON functions in PostgreSQL 9.2. Specifically, given a series …
sql json postgresql postgresql-9.2 postgresql-9.3I've recently been playing around with Docker and QGIS and have installed a container following the instructions in this tutorial. …
ubuntu docker postgresql-9.3 qgisI have a sequence on postgresql 9.3 inside a schema. I can do this: SELECT last_value, increment_by from foo."…
postgresql postgresql-9.3I have a table to store information about my rabbits. It looks like this: create table rabbits (rabbit_id bigserial …
json postgresql postgresql-9.3I try to copy the content of a CSV file into my postgresql db and I get this error "extra …
postgresql csv postgresql-9.3How can I list all the tables of a PostgreSQL database and order them by size?
sql postgresql postgresql-9.3Using PostgreSQL 9.3, I want to convert the calculated values to data type float. My first attempt: SELECT float(SUM(Seconds))/…
sql postgresql casting type-conversion postgresql-9.3In PostgreSQL 9.3 Beta 2 (?), how do I create an index on a JSON field? I tried it using the -> …
json postgresql indexing postgresql-9.3I have a materialized view on a PostgreSQL 9.3 database which seldom changes (about twice a day). But when it does, …
postgresql triggers postgresql-9.3 materialized-views