Skip to content

Instantly share code, notes, and snippets.

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