Help Center/ GaussDB(DWS)/ FAQs/ Database Use/ How Do I Export a GaussDB(DWS) Table Schema?
Updated on 2025-07-22 GMT+08:00
View PDF
Share

How Do I Export a GaussDB(DWS) Table Schema?

Using SQL Editor

You are advised to use SQL Editor to export table data. Log in to a data source, select the corresponding database and schema, enter the SQL statement for querying table data, and click Export. The following export methods are supported:

  • Local export: Export all SQL query results to an XLSX or CSV file. You can open the file on your local PC. A maximum of 20,000 records can be exported.
  • Full export: Export all query SQL results to a specified path in an OBS bucket. By default, the results are exported to a CSV file.

For details, see Exporting Data.

Using gs_dump and gs_dumpall

Alternatively, you can use gs_dump and gs_dumpall to export data.

  • Exporting a single database:
    • Database-level export
    • Schema-level export
    • Table-level export
  • Exporting all databases:
    • Database-level export
    • global object export of each database

For details, see gs_dump and gs_dumpall.

Parent topic: Database Use