Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Generate UUID

Generate a random UUID using `uuid-ossp`.

Back to sheetBrowse commands
Sign in to save
Section: Extensions and Specialized Utilities

Generate UUID

sql
sql
SELECT uuid_generate_v4();
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Extensions and Specialized Utilities
Enable uuid-ossp
Install UUID generation helpers.
OpenIn sheetsqlsame section
Enable pg_trgm
Install trigram support for similarity search and GIN/GiST indexes.
OpenIn sheetsqlsame section
Create trigram index
Accelerate ILIKE and fuzzy matches on text.
OpenIn sheetsqlsame section
Enable citext
Install case-insensitive text type support.
OpenIn sheetsqlsame section
Use CITEXT
Make a column case-insensitive with the `citext` type.
OpenIn sheetsqlsame section
Enable pgstattuple
Install size and tuple-stat inspection helpers.
OpenIn sheetsqlsame section