if not exists – select * from depesz;

Waiting for 9.6 – Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN

On 30th of July, Andrew Dunstan committed patch:

Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN
 
Fabrízio de Royes Mello, reviewed by Payal Singh, Alvaro Herrera and
Michael Paquier.

Continue reading Waiting for 9.6 – Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN

Waiting for 9.1 – CREATE TABLE IF NOT EXISTS

On 25th Robert Haas committed patch which adds first of ‘CREATE IF NOT EXISTS' commands:

Log Message:
-----------
CREATE TABLE IF NOT EXISTS.
 
Reviewed BY Bernd Helmle.

Continue reading Waiting for 9.1 – CREATE TABLE IF NOT EXISTS