Postgres uuid

From UVOO Tech Wiki
Revision as of 15:24, 2 April 2023 by Busk (talk | contribs)
Jump to navigation Jump to search 
select gen_random_uuid ();

select replace((select gen_random_uuid()::TEXT), '-', '') ;


CREATE OR REPLACE FUNCTION jb()
RETURNS TEXT AS $$
DECLARE
  rtv TEXT := 'test';
  _uuid text := (select replace((select gen_random_uuid()::TEXT), '-', ''));
BEGIN
  -- PERFORM 'test';
  -- PERFORM uuid;
  CREATE ROLE _uuid;
  RETURN _uuid;
END;
$$  LANGUAGE plpgsql;
Retrieved from "https://tech.uvoo.io/index.php?title=Postgres_uuid&oldid=3943"