Adding a new value to an existing ENUM Type

by

PostgreSQL 9.1 introduces ability to ALTER Enum types:

ALTER TYPE enum_type ADD VALUE 'new_value'; -- appends to list
ALTER TYPE enum_type ADD VALUE 'new_value' BEFORE 'old_value';
ALTER TYPE enum_type ADD VALUE 'new_value' AFTER 'old_value';

More Related Contents:

  1. Keep PostgreSQL from sometimes choosing a bad query plan
  2. Copying PostgreSQL database to another server
  3. Primary keys with Apache Spark
  4. How can I put a database under git (version control)?
  5. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  6. Store query result in a variable using in PL/pgSQL
  7. Can I rollback a transaction I’ve already committed? (data loss)
  8. Kill a postgresql session/connection
  9. PostgreSQL: Drop PostgreSQL database through command line [closed]
  10. Do stored procedures run in database transaction in Postgres?
  11. Import SQL dump into PostgreSQL database
  12. how to use Blob datatype in Postgres
  13. How can I solve Postgresql SCRAM authentication problem?
  14. Convert SQLITE SQL dump file to POSTGRESQL
  15. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  16. How to login and authenticate to Postgresql after a fresh install?
  17. PostgreSQL Database Log Transaction
  18. Connect to a heroku database with pgadmin
  19. How do I automatically update a timestamp in PostgreSQL
  20. Starting and populating a Postgres container in Docker
  21. How can I import a .sql file into my Heroku postgres database?
  22. Backup/Restore a dockerized PostgreSQL database
  23. How to recover a corrupt SQLite3 database?
  24. Partial Dependency (Databases)
  25. How to display table data more clearly in oracle sqlplus
  26. What is the most efficient way to store tags in a database?
  27. Microservices with shared database? using multiple ORM’s? [closed]
  28. What’s the best strategy for unit-testing database-driven applications?
  29. What are the use cases of Graph-based Databases (http://neo4j.org/)? [closed]
  30. Is it a good idea to use an integer column for storing US ZIP codes in a database?

Leave a Comment