Import & Export

PulseDB supports importing SQL files and exporting database schemas and data in multiple formats, both for individual tables and for the whole database.

Import

SQL Import

Import SQL files to execute batch operations:

  1. Click Import in the toolbar
  2. Select an SQL file
  3. Review the SQL statements
  4. Click Execute to run them

The import supports:

  • CREATE TABLE statements
  • INSERT statements
  • CREATE INDEX statements
  • Multi-line SQL scripts

Database export

Open File → Export Database from the header to export the entire database (all selected schemas) in one of these formats:

FormatDescription
SQL dumpFull schema + data as a transactional SQL script (DDL and INSERT statements)
JSONSchema and table rows as a single .json document
CSVOne .csv file per table, bundled into a single .zip archive
SQL schema onlyDDL only — CREATE TABLE, indexes, constraints, sequences, triggers, views, and functions. No data.

Options:

  • Schemas — pick which schemas to include (all non-system schemas by default)
  • DDL / Data / Functions — toggle what the SQL dump includes (SQL dump only)
  • Max rows per table — limit how many rows are exported per table

After exporting you can Download the file or Copy the result to the clipboard.

Schema export (DDL only)

Open File → Export Schema (DDL only) to generate a complete structure-only replica of the database as SQL — without any data. The output includes:

  • CREATE SCHEMA for all non-system schemas
  • Enum types and sequences
  • CREATE TABLE with columns, defaults, identity columns, and primary keys
  • Foreign keys, unique, and check constraints (added via ALTER TABLE so reference order never matters)
  • Indexes, triggers, views, materialized views, and functions/procedures
  • Table comments

The script is wrapped in a transaction (BEGIN; / COMMIT;) so you can import it directly — for example into a fresh, empty database.

Table export

How to export a table

  1. Navigate to a table or view
  2. Click Export in the toolbar
  3. Choose the export format
  4. Select what to include (schema, data, or both)
  5. Click Export to download

CSV export specifics

  • Includes header row by default
  • Handles special characters and escaping
  • UTF-8 encoding