How can I add a column that doesn’t allow nulls in a Postgresql database?

by

You have to set a default value.

ALTER TABLE mytable ADD COLUMN mycolumn character varying(50) NOT NULL DEFAULT 'foo';

... some work (set real values as you want)...

ALTER TABLE mytable ALTER COLUMN mycolumn DROP DEFAULT;

More Related Contents:

  1. How do I alter the position of a column in a PostgreSQL database table?
  2. Does PostgreSQL support “accent insensitive” collations?
  3. PostgreSQL: running count of rows for a query ‘by minute’
  4. Split comma separated column data into additional columns
  5. IN vs ANY operator in PostgreSQL
  6. How to delete duplicate entries?
  7. Transpose latest rows per user to columns
  8. Split column into multiple rows in Postgres
  9. Compute percents from SUM() in the same SELECT sql query
  10. Getting date list in a range in PostgreSQL
  11. Postgres Dynamic Query Function
  12. How do I delete a fixed number of rows with sorting in PostgreSQL?
  13. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  14. sqlite alter table add MULTIPLE columns in a single statement
  15. Error: Column does not exist
  16. DROP FUNCTION without knowing the number/type of parameters?
  17. Multiple array_agg() calls in a single query
  18. PostgreSQL does not accept column alias in WHERE clause
  19. Calculate working hours between 2 dates in PostgreSQL
  20. How to show row numbers in PostgreSQL query?
  21. How do I ALTER a PostgreSQL table and make a column unique?
  22. Find records where join doesn’t exist
  23. Counting the number of occurrences of a substring within a string in PostgreSQL
  24. Upsert with a transaction
  25. psql invalid command \N while restore sql
  26. To ignore duplicate keys during ‘copy from’ in postgresql
  27. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  28. Join a count query on generate_series() and retrieve Null values as ‘0’
  29. Store and reuse value returned by INSERT … RETURNING
  30. SQL SET DEFAULT not working in MS Access

Leave a Comment