IntelliJ IDEA
 
2024.3
Get IntelliJ IDEA

Export

Last modified: 11 October 2024

You can use a variety of methods to export data and object structure from your databases. These methods include usage of various generators, data extractors, and shortcuts. Also, you can export data in TXT, CSV, JSON, XML, Markdown, Excel, and other formats. You can select a predefined data extractor or create your own.

In IntelliJ IDEA, you export object structure and data separately. It means that you can export a structure of a table or a view and then export data from these objects.

The full data dump is available for PostgreSQL and MySQL with the help of mysqldump and pg_dump. The full data dump includes the structure of all database objects and data of these objects in a single file. For more information, refer to Create a full data dump for MySQL and PostgreSQL.