How to add column if not exists on PostgreSQL?

by

With Postgres 9.6 this can be done using the option if not exists

ALTER TABLE table_name ADD COLUMN IF NOT EXISTS column_name INTEGER;

More Related Contents:

  1. How to exit from PostgreSQL command line utility: psql
  2. Generating time series between two dates in PostgreSQL
  3. I forgot the password I entered during postgres installation
  4. Generate series of dates – using date type as input
  5. Test for null in function with varying parameters
  6. Postgres query optimization (forcing an index scan)
  7. Dynamically generate columns for crosstab in PostgreSQL
  8. I forgot the password I entered during PostgreSQL installation
  9. PostgreSQL ERROR: canceling statement due to conflict with recovery
  10. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  11. Postgresql insert trigger to set value
  12. now() default values are all showing same timestamp
  13. Convert escaped Unicode character back to actual character in PostgreSQL
  14. Insert, on duplicate update in PostgreSQL?
  15. How does the search_path influence identifier resolution and the “current schema”
  16. How do you find the row count for all your tables in Postgres
  17. Run batch file with psql command without password
  18. invalid byte sequence for encoding “UTF8”
  19. Postgresql: Conditionally unique constraint
  20. How do you use variables in a simple PostgreSQL script?
  21. How to switch databases in psql?
  22. Compute percents from SUM() in the same SELECT sql query
  23. Postgresql Truncation speed
  24. Buffers (Circle) in PostGIS
  25. How to customize the configuration file of the official PostgreSQL Docker image?
  26. Does a Postgres UNIQUE constraint imply an index?
  27. postgres autoincrement not updated on explicit id inserts
  28. Retrieving Comments from a PostgreSQL DB
  29. PostgreSQL how to concat interval value ‘2 days’
  30. Displaying image in Ireports using PostgreSql

Leave a Comment