GoLand
 
2022.2
Shortcuts: Windows
Get GoLand
You are viewing the documentation for an earlier version of GoLand.
  1. Integrated tools
  2. Database tools and SQL
  3. Database design
  4. Tables
  5. Copy

Copy

Last modified: 17 March 2022

You can duplicate a table in the current schema or copy it to another schema or data source.

Create a table copy

  • Drag a table to the node in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.

    https://resources.jetbrains.com/help/img/idea/2022.2/db_create_table_copy_by_dragging.png
    Gif

  • Right-click a table and select Copy Table to… (F5). In the Choose Target dialog, type the name of a schema in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.

    https://resources.jetbrains.com/help/img/idea/2022.2/db_create_table_copy_context_menu.png
    Gif

  • In the data editor, click the Copy to Database… icon (Copy to Database) and select a schema to which you want to copy the table.

    Check the video at youtube.com to see the live example.