PyCharm
 
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.

Export

Last modified: 20 September 2023

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 PyCharm, 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 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.