Texonom
Texonom
/
Engineering
Engineering
/Data Engineering/DataBase/Database Type/RDBMS/PostgreSQL/Postgres Extension/
postgre uuid-ossp
Search

postgre uuid-ossp

Creator
Creator
Seonglae Cho
Created
Created
2020 Dec 28 9:30
Editor
Editor
Seonglae Cho
Edited
Edited
2023 Apr 17 14:45
Refs
Refs
CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; select uuid_generate_v4()
 
Generating a UUID in Postgres for Insert statement?
The answer by Craig Ringer is correct. Here's a little more info for Postgres 9.1 and later... You can only install an extension if it has already been built for your Postgres installation (your cluster in Postgres lingo). For example, I found the uuid-ossp extension included as part of the installer for Mac OS X kindly provided by EnterpriseDB.com.
Generating a UUID in Postgres for Insert statement?
https://stackoverflow.com/questions/12505158/generating-a-uuid-in-postgres-for-insert-statement
Generating a UUID in Postgres for Insert statement?
uuid-ossp
Development Versions: devel This documentation is for an unsupported version of PostgreSQL. You may want to view the same page for the current version, or one of the other supported versions listed above instead. The uuid-ossp module provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms. There are also functions to produce certain special UUID constants.
uuid-ossp
https://www.postgresql.org/docs/9.4/uuid-ossp.html
uuid-ossp

Recommendations

Texonom
Texonom
/
Engineering
Engineering
/Data Engineering/DataBase/Database Type/RDBMS/PostgreSQL/Postgres Extension/
postgre uuid-ossp
Copyright Seonglae Cho