Help Center/ GaussDB(DWS)/ FAQs/ Database Usage/ How Can I Export the Table Structure?
Updated on 2023-04-26 GMT+08:00

How Can I Export the Table Structure?

You are advised to use the Data Studio graphical client to export table data. You can export data from:

  • A specific table
  • All tables in a schema
  • All tables in a database

For details, see Exporting Table Data.

Alternatively, use gs_dump and gs_dumpall to export data. You can:

  • Export a single database:
    • Database-level export
    • Mode-level export
    • Table-level export
  • Export all databases:
    • Database-level export
    • Exporting global objects from each database

For details, see gs_dump and gs_dumpall.