Skip to content
Skip to content
PGB Learn

Import existing data

Two ways

Both are on Databases > Backups.

Import from another database

  1. Find Import from another database and choose Supabase, Neon or Other Postgres.
  2. Paste the Connection string. The source must be reachable from the internet and its user needs read access.
  3. Choose Check source. It is read-only and the string is never saved.
  4. Review: schemas to import (untick any), schemas left behind because they belong to the other platform, extensions that will be installed, and any problems such as unsupported extensions or a source over the size limit.
  5. If your target already has data, you must type the database name and choose I understand the consequences, replace and import. Replacing requires Owner or Admin.
  6. Watch the progress. The import is a single transaction with row-count checks, so a failure changes nothing.

Upload a dump

Choose Upload & Restore Dump... and select a .sql or .sql.gz file. Meta-commands in the file are refused.

Prepare

  • Take an instant backup of the target.
  • Enable the extensions you need in DB Settings.

After

Run the Query Advisor (Run Audit) to spot missing indexes, then switch your app's connection string.

Try it

Import a small test dump into a scratch database.

Recap

  • Check first, then import; nothing is copied until you confirm.
  • Replace needs a typed confirmation.

Open Access Course

Free

forever
  • 9 structured lessons across 6 modules
  • Interactive knowledge checks with instant feedback
  • Verifiable completion certificate & PDF