Skip to content

Instantly share code, notes, and snippets.

@stevehenderson

stevehenderson/postgres_show_partion_with_rows.sql

Created March 23, 2023 01:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stevehenderson/97acd3af4a22d3d68c089473026da659 to your computer and use it in GitHub Desktop.
Save stevehenderson/97acd3af4a22d3d68c089473026da659 to your computer and use it in GitHub Desktop.
Download ZIP
Query a postgres table with partitions and show the partition
Raw
postgres_show_partion_with_rows.sql
SELECT tableoid::regclass AS source, *
FROM schema.partitioned_table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment