for PostgreSQL questions specific to version 9.2.
From postgresql documentation: RESTRICT prevents deletion of a referenced row. NO ACTION means that if any referencing rows still exist …
sql postgresql postgresql-9.2I am using postgres 9.2. I need to change all column name to UPPER CASE for all tables in postgres db. …
postgresql postgresql-9.2The following is a snippet of a table called "containers". Column | Type | Modifiers --------------------+-----------------------------+--------------------------------- id | uuid | not null …
arrays database postgresql postgresql-9.2I found how to add value to the TYPE. But how can I remove value from it? For example I …
postgresql postgresql-9.2How to map below query to postgres function. WITH RECURSIVE source (counter, product) AS ( SELECT 1, 1 UNION ALL SELECT counter + 1, product * (…
postgresql plpgsql postgresql-9.2 recursive-queryI want to set the application name of the connections of my application. So when I list the rows in …
postgresql url jdbc postgresql-9.2I have a function called "getList(date)". This function returns me a items list (with several columns) from the date …
postgresql function postgresql-9.2I 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.4If i have a column say column a of any given values, and i want another column column b to …
postgresql database-design triggers default-value postgresql-9.2I have the following table in PostgreSQL 9.2 which contains time stamps: gid [PK] (bigserial), timestamp_mes (timestamp without time zone), …
sql database postgresql sql-update postgresql-9.2