https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html#:~:text=ALTER%20DEFAULT%20PRIVILEGES%20allows%20you,objects%20created%20in%20specified%20schemas.
Two ways: 1.) alter sequence restart 2.) select setval(); Both show below, both work but setval is preferred as it
select gen_random_uuid ()::text; select translate(gen_random_uuid ()::text,’-‘,”); select translate(‘abc-def’, ‘-‘, ”); select length(gen_random_uuid ()::text); select length(translate(gen_random_uuid ()::text,’-‘,”));
Run the two commands below and you will see what I mean: select now() AT TIME ZONE current_setting(‘timezone’); 2023-09-30 09:07:31.251
select a.oid as user_role_id , a.rolname as user_role_name , b.roleid as other_role_id , c.rolname as other_role_name from pg_roles a inner
https://aws.amazon.com/blogs/database/migrating-oracle-autonomous-transactions-to-postgresql/ in other words how to write a error log to a table and separately commit that record
Here is the entire list for native on-prem PostgreSQL: https://www.postgresql.org/docs/current/monitoring.html And here are my favorites from that list. PG_STAT_ACTIVITY –
The Best of Series momjian.us/presentations The presentation above addresses requirements open source (mostly free solutions) for PostgreSQL functionality to: –
On-prem? PgBouncer AWS RDS Postgres or AWS RDS Aurora/PostgreSQL? AWS RDS Proxy