How do you create a random string that’s suitable for a session ID in PostgreSQL?

by

You can fix your initial attempt like this:

SELECT md5(random()::text);

Much simpler than some of the other suggestions. 🙂

More Related Contents:

  1. quick random row selection in Postgres
  2. Postgres FOR LOOP
  3. What is PostgreSQL equivalent to autoincrement?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. psql: FATAL: Ident authentication failed for user “postgres”
  6. Use multiple conflict_target in ON CONFLICT clause
  7. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  8. How to find table creation time?
  9. Go and IN clause in Postgres
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Migrate database from Postgres to MySQL [closed]
  14. How can I start PostgreSQL on Windows?
  15. PostgreSQL – max number of parameters in “IN” clause?
  16. SQLAlchemy, Psycopg2 and Postgresql COPY
  17. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  18. Why can I create a table with PRIMARY KEY on a nullable column?
  19. Oracle SQL Developer and PostgreSQL
  20. PostgreSQL array of elements that each are a foreign key
  21. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  22. Can I use return value of INSERT…RETURNING in another INSERT?
  23. Changing a postgres containers server port in Docker Compose
  24. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  25. PostgreSQL – disabling constraints
  26. PostgreSQL authentication method 10 not supported
  27. Heroku database restore issue
  28. user postgres launches process that takes all CPUs 100% usage
  29. Postgres table column name restrictions?
  30. How do I get min, median and max from my query in postgresql?

Leave a Comment