GraphBear/find_toast_table_parent.sql

Created August 27, 2020 16:12

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

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

Download ZIP

find parent table of a toast table in postgresql

Raw

find_toast_table_parent.sql

	select
	relname
	from
	pg_class
	where
	reltoastrelid = ( select oid from pg_class where relname = 'toast_table_name' );

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