Скачать или смотреть UUID (Universal Unique IDentifier) in PostgreSQL

In this PostgreSQL tutorial we'll tell you what UUIDs (Universal Unique Indentifiers) in PostgreSQL are and how they work.

To use UUID, install the "uuid-ossp" extension with a SQL query like so:
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

This PostgreSQL database extension provides you with the uuid_generate_v4() extension.

To use the gen_random_uuid() function, install pgcrypto:
CREATE EXTENSION IF NOT EXISTS "pgcrypto";

The gen_random_uuid(); function is provided by pgcrypto.

The uuid_generate_v4(); function is provided by uuid-ossp.

PostgreSQL suggests using the implementation of pgcrypto.

uuid_generate_v4() uses arc4random to determine randomness, while gen_random_uuid(); uses fortuna instead.

Keep in mind that PostgreSQL doesn't generate UUIDs by itself.

Tell us in the comment section below - do you prefer using pgcrypto or uuid-ossp?

Make sure to subscribe to this database channel to gain more insight into database interview questions, sql interview questions and answers surrounding mysql server, the postgresql database, mysql vs nosql, and so on. Do you want to see a PostgreSQL crash course on the channel? Let us know!

Music:
Resistance by GalaxyTones   / galaxytones  
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/45q0DYV
Music promoted by Audio Library:    • Atmospheric, Melodic, Trap No Copyright Mu...  

#database #postgresql #sql #shorts #reels #web #developer #webdevelopment