Postgres uuid - Revision history

Busk at 15:38, 2 April 2023

2023-04-02T15:38:37Z

2023-04-02T15:29:58Z

2023-04-02T15:24:47Z

2023-04-02T14:37:47Z

2023-04-02T14:28:45Z

Created page with "select gen_random_uuid ();"

New page

select gen_random_uuid ();

← Older revision		Revision as of 15:38, 2 April 2023
Line 1:		Line 1:
		+	```
		+	CREATE OR REPLACE FUNCTION create_role()
		+	RETURNS TEXT AS $$
		+	DECLARE
		+	_uuid text := (select replace((select gen_random_uuid()::TEXT), '-', ''));
		+	BEGIN
		+	execute format('create role u%s',_uuid);
		+	RETURN _uuid;
		+	END;
		+	$$ LANGUAGE plpgsql;
		+	```
		+
	```		```
	select gen_random_uuid ();		select gen_random_uuid ();

← Older revision		Revision as of 15:29, 2 April 2023
Line 6:		Line 6:
	```		```

		+	```
		+	create or replace function create_user_readonly (
		+	unm varchar,
		+	pwd varchar
		+	)
		+	returns varchar(10) as $$
		+
		+	begin
		+
		+	execute format($f$create role %I login password '%s'$f$,unm,pwd);
		+	execute format('alter role %I set transaction_read_only to on',unm);
		+	return 'success';
		+
		+	end;
		+
		+	$$ language plpgsql;
		+	```

	```		```

← Older revision		Revision as of 15:24, 2 April 2023
Line 4:		Line 4:
	select replace((select gen_random_uuid()::TEXT), '-', '') ;		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;
	```		```

← Older revision		Revision as of 14:37, 2 April 2023
Line 1:		Line 1:
		+	```
	select gen_random_uuid ();		select gen_random_uuid ();
		+
		+	select replace((select gen_random_uuid()::TEXT), '-', '') ;
		+
		+	```