Adding UUID functionality to your psql server (uuid-ossp)

Will Barnes
Jul 29, 2017 · 1 min read

Steps

Login as postgres

$ psql -U postgres

Check to see if “uuid-ossp” is installed on your db server

select * from pg_extension;

If it is installed you should see it listed like it is below

If not present, install “uuid-ossp”

# CREATE EXTENSION "uuid-ossp";

Verify that it was installed correctly

# select * from pg_extension;

To see a list of available pg plugins you can type

# select * from pg_available_extensions;

Tangential Note: dropping an extension
* Ref: sql-dropextension
If you find the need to remove the uuid-ossp extension, you can do so by executing the below command.

# DROP EXTENSION "uuid-ossp";

Will Barnes

Written by

An intelligent fool, stubbornly optimistic, relentlessly persistent, tech-cofounder at cProject

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade