for PostgreSQL questions specific to version 9.4
I am using Postgresql 9.4 and have a table test, with id::int and content::jsonb, as follows: id | content ----+…
sql json postgresql postgresql-9.4 jsonbI am using postgresql 9.4 and while writing functions I want to use self-defined error_codes (int). However I may want …
postgresql global-variables postgresql-9.4There are two tables: Authorized Contacts (auth_contacts): ( userid varchar contacts jsonb ) contacts contains an array of contacts with attributes {…
sql postgresql-9.4 jsonbI have a variable 'x' which is varchar in staging table, but it is set to boolean in target table …
postgresql postgresql-9.3 postgresql-9.2 postgresql-9.4Is it possible to SELECT * but without n-th column, for example 2nd? I have some view that have 4 and 5 columns (…
postgresql postgresql-9.4I have created a separate role "newrole" and new schema "newschema" for a certain user that should only execute some …
postgresql postgresql-9.4I have the following SQL statement: SELECT * FROM schema."table" WHERE "TimeStamp"::timestamp >= '2016-03-09 03:00:05' ORDER BY "…
postgresql postgresql-9.4I'm using AWS Aurora Postgres and using DMS to migrate from RDS postgres to Aurora PG. In order to perform …
postgresql postgresql-9.1 postgresql-9.4 amazon-rds-aurora aws-dmsI 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.6I get a little confused some times when working with psql between when to use a set vs. \set vs. \…
postgresql psql postgresql-9.4