Skip to content

Instantly share code, notes, and snippets.

@exy02
Created September 26, 2020 19:11
Show Gist options
  • Save exy02/17f8811f15aec64e6e37a286c0cedc33 to your computer and use it in GitHub Desktop.
Save exy02/17f8811f15aec64e6e37a286c0cedc33 to your computer and use it in GitHub Desktop.
Simplified PostgreSQL querying (with or without SSH) - Return Tables
pgres.tables(db='database_name',schema='schema_name')
#returns the number of tables and all table names within the specified schema as a pandas dataframe
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment