Import and Export Data

Export via the Grid

Run a query, click the Download/Export icon in the results, choose CSV, delimiters, and quoting. Export honors the query filters, giving filtered reports instantly.

Export a Whole Table

Query tool > Query > Export lets you pick a destination file and format (CSV, Excel, JSON). For whole-table dumps, prefer pg_dump tools instead.

Import into a Table

Right-click the table > Import/Export Data, set format CSV, locator to the file, and enable header row. The wizard previews column mapping before running COPY.

Encoding and Errors

Specify the CSV encoding that matches the file; typos or type mismatches abort with a clear row/column error for repair and retry.

Key Points

• Query results export directly to files.
• Import runs COPY behind the scenes.
• Header and encoding controls keep data clean.
• Table-level dumps use the backup features.