vilmid/tables.sql

Created October 4, 2021 05:19

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/vilmid/acb45759a9b8f801bfdb0831eae805ca.js"></script>
Save vilmid/acb45759a9b8f801bfdb0831eae805ca to your computer and use it in GitHub Desktop.

Download ZIP

Raw

	SELECT
	tablename
	, tableowner
	FROM
	pg_tables
	WHERE
	tableowner <> 'postgres'
	;

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