ENUM type in SQLAlchemy with PostgreSQL

by

You need to import Enum from sqlalchemy and add a name to it. It should work like this:

from sqlalchemy import Enum

person = Table("user_profile", metadata,
    Column("name", String(20)),
    Column("gender", Enum("female", "male", name="gender_enum", create_type=False))
);

Related Contents:

  1. SQL query to get all values a enum can have
  2. How to delete an enum type value in postgres?
  3. SQLAlchemy support of Postgres Schemas
  4. Is there a way to show a user-defined postgresql enumerated type definition?
  5. How can I do multiple “order_by” in Flask-SQLAlchemy?
  6. Setting application_name on Postgres/SQLAlchemy
  7. SQLAlchemy no password supplied error
  8. How to query a JSON element
  9. uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
  10. Alembic: alter column type with USING
  11. error: ALTER TYPE … ADD cannot run inside a transaction block
  12. psql – save results of command to a file
  13. How to stop/kill a query in postgresql? [duplicate]
  14. Can PostgreSQL index array columns?
  15. Truncating all tables in a Postgres database
  16. How do I change column default value in PostgreSQL?
  17. Why unsigned integer is not available in PostgreSQL?
  18. Typecast string to integer
  19. How to restart Postgresql
  20. Increment a value in Postgres
  21. What is PostgreSQL explain telling me exactly?
  22. The infamous java.sql.SQLException: No suitable driver found
  23. Adding comment to column when I create table in PostgreSQL?
  24. PostgreSQL: Remotely connecting to Postgres instance using psql command
  25. How to create an SQL View with SQLAlchemy?
  26. How to rename a table inside a schema?
  27. Postgres SELECT where the WHERE is UUID or string
  28. What’s the difference between sudo su – postgres and sudo -u postgres?
  29. Django: CONN_MAX_AGE persists connections, but doesn’t reuse them with PostgreSQL
  30. PostgreSQL timezone does not match system timezone
  31. Check Postgres access for a user
  32. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  33. How do I do large non-blocking updates in PostgreSQL?
  34. Postgresql insert trigger to set value
  35. CREATE TABLE AS with PRIMARY KEY in one statement (PostgreSQL)
  36. Turn postgres date representation into ISO 8601 string
  37. Destroying a Postgres DB on Heroku
  38. Why command \dt gives – no relations found?
  39. update if row with some unique value exists, else insert
  40. Postgres shuts down immediately when started with docker-compose
  41. Build postgres docker container with initial schema
  42. pg_dump vs pg_dumpall? which one to use to database backups?
  43. ERROR: cannot execute CREATE TABLE in a read-only transaction
  44. PostgreSQL- Filter a date range
  45. org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host
  46. How to use volume in docker compose for postgres?
  47. Postgresql delete old rows on a rolling basis?
  48. PGAdmin Edit data
  49. Does PostgreSQL support transparent compressing of tables (fragments)?
  50. PL/pgSQL perform vs execute

Leave a Comment