In PostgreSQL, I am loading the uuid-ossp
extension so I can use the function that creates random UUIDs in my queries:
create extension if not exists "uuid-ossp";
However, as well as making available the one function I need (uuid_generate_v4
), it also makes nine other functions that I don't need available:
(Using \df
on the command-line shows the same data). Is there any way I can, using programming terms, "import" just the uuid_generate_v4
function into my "namespace", without importing the ones I'm not using?
gen_random_uuid()
from pgcrypto is a lot faster than uuid_generate_v4)