Skip to content

Instantly share code, notes, and snippets.

@davehague

davehague/Export Supabase Table Schemas.md

Created April 17, 2024 19:01
Show Gist options
  • Save davehague/450ce8f9c19e5184f9943ad9d6a41b84 to your computer and use it in GitHub Desktop.
Save davehague/450ce8f9c19e5184f9943ad9d6a41b84 to your computer and use it in GitHub Desktop.
Download ZIP
Export Supabase Table Schemas
Raw
Export Supabase Table Schemas.md

Setup

  1. Download and install pgAdmin
  2. Get your Supabase connection settings from the database settings page.

Export

In pgAdmin:

  1. Right click the schema and choose 'CREATE script' to script the schema
  2. Right click the schema and choose 'BACKUP...' to script the tables
    • For filename put in a FULL path ("C:/users/name/Downloads/export.sql")
    • In 'Objects' select the object you want to export
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment