Skip to content

Instantly share code, notes, and snippets.

DO $$ DECLARE
r RECORD;
BEGIN
FOR r IN (
SELECT tablename as entry
FROM pg_tables
WHERE
schemaname = current_schema())
LOOP
EXECUTE 'DROP TABLE ' || quote_ident(r.entry) || ' CASCADE';
@BacLuc
BacLuc / change-owner.sql
Created August 8, 2025 08:05
Change owner of postgres db objects
DO $$ DECLARE
r RECORD;
target_user text := 'target-user';
statement text;
BEGIN
-- table
FOR r IN (
SELECT tablename as entry
FROM pg_tables
WHERE
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 931.3676386499999,
"max": 3500.330784,
"med": 669.9648735000001,
"min": 277.3991,
test
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 631.12776445,
"max": 1665.518257,
"med": 584.0268055,
"min": 289.911717,
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 631.6030709473683,
"max": 2068.760395,
"med": 488.433992,
"min": 388.672869,
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 8681.280807421053,
"max": 31590.196952,
"med": 949.095752,
"min": 294.040104,
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 3515.3106153,
"max": 5998.287294,
"med": 3708.5206390000003,
"min": 465.955339,
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 324.82173282,
"max": 2176.927984,
"med": 285.1435935,
"min": 124.762554,
{
"metrics": {
"_api_": {
"contains": "default",
"type": "trend",
"values": {
"avg": 1718.7342479799993,
"max": 4338.901657,
"med": 1615.4185105000001,
"min": 453.363273,