ir4y · November 27, 2013 04:48
diff --git a/change_owner.sh b/change_owner.sh
 #!/bin/bash
 #usage change_owner.sh database_name new_owner_name
 for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" $1` ; do
 psql -c "alter table $tbl owner to $2" $1 ; 
 done
	#!/bin/bash
	#usage change_owner.sh database_name new_owner_name
	for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" $1` ; do
	psql -c "alter table $tbl owner to $2" $1 ;
	done
No results found