Export

Available for admins and managers

Export SQL

When clicking the Export SQL button a new SQL dump will be created with pg_dump.

  • Be aware, especially when sharing, that user data, e.g. email addresses, is included.

  • Existing files are shown in a list and can be downloaded or deleted (only admins can delete)

  • If the directory isn’t writable, a warning will be shown

  • SQL dumps are saved in the export/sql folder

  • File names begin with date and time e.g. 2018-08-23_1533_dump.sql.

Export CSV

When clicking the Export CSV button a new CSV export file for all marked tables will be created.

  • Existing files are shown in a list and can be downloaded or deleted (only admins can delete)

  • If the directory isn’t writable, a warning will be shown

  • CSV exports are saved in the export/csv folder

  • File names are constructed from the date, database schema and table name e.g. 2018-08-23_1533_model_class.csv

Options

  • Export as ZIP and add info file - files are compressed with an info file (date, username, domain)

  • Created and modified dates - additional columns for creation and last modified dates

  • GIS format