Popular "postgresql-9.6" questions

Once upon a time I had a Postgres database that worked with pgAdmin. I have a webservice running on a …

postgresql postgresql-9.6 pgadmin-4

Postgresql query for objects in nested JSONB field

I am using PostgreSQL 9.6, and I have a table named "ItemDbModel" with two columns looks like: No integer, Content jsonb …

json postgresql jsonb postgresql-9.6 postgresql-12

Postgresql | No space left on device

I am getting space issue while running a batch process on PostgreSQL database. However, df -h command shows that machine …

postgresql database-administration postgresql-9.6

Querying Postgres 9.6 JSONB array of objects

I have the following table: CREATE TABLE trip ( id SERIAL PRIMARY KEY , gps_data_json jsonb NOT NULL ); The JSON …

postgresql jsonb postgresql-9.6

query.on is not a function

I am trying to learn how to use javascript to connect to a postgresql database but when I try to …

javascript node.js postgresql-9.6 node-postgres

How to INSERT now() + INTERVAL in Postgres 9.x

I'm trying to INSERT a future date into a timestamp with time zone column in a table in Postgres 9.6.2. I'd …

sql postgresql timestamp postgresql-9.6

Postgresql update json data property

I created a field name is result and type is text. I just want to update 'lat' in column. When …

json postgresql jsonb postgresql-9.4 postgresql-9.6

Error in creating SEQUENCEs when restoring the PostgreSQL database

UserX has following grants: CREATE ROLE "UserX" LOGIN PASSWORD 'pass'; CREATE DATABASE "DBX" WITH OWNER="UserX" ENCODING='UTF8' TABLESPACE=…

postgresql postgresql-9.6 pg-restore

Postgres find configuration files in linux

I've spent lots of time to find Postgres configuration files like pg_hba.conf or postgresql.conf in different distributions …

postgresql postgresql-9.1 postgresql-9.6 pg-hba.conf

When we need return value from trigger procedure?

Documentation about trigger procedures (https://www.postgresql.org/docs/9.6/static/plpgsql-trigger.html) says: "A trigger function must return either NULL …

database postgresql triggers postgresql-9.6

Top "Postgresql-9.6" questions