sebastianwebber/new-owner.sql

Created February 1, 2016 18:24

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sebastianwebber/37532c12542c208fd862.js"></script>
Save sebastianwebber/37532c12542c208fd862 to your computer and use it in GitHub Desktop.

Download ZIP

SELECT to generate new table owner in PostgreSQL

Raw

new-owner.sql

	SELECT
	'ALTER TABLE ' \|\|
	schemaname \|\| '.' \|\| relname \|\|
	' OWNER TO novo_user;'
	FROM pg_stat_user_tables;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment