DataChange rows
Copy table data
Discover how to copy table data without using SQL.
Open a table
Section titled “Open a table”In the Connections view, connect to your database, expand the database and Tables, then select a table to open its data grid.
Copy selected cells
Section titled “Copy selected cells”Click and drag across the cells you want to copy.

Right-click the selection and choose Copy to copy the values without headers. To choose a format, open Copy As > Selection, then select the format.

Copy all rows
Section titled “Copy all rows”To copy the complete result set, right-click inside the grid and open Copy As > All, then select a format.

Copy the table name
Section titled “Copy the table name”In a table’s tab, press Ctrl+Alt+C (Cmd+Option+C on macOS), or run DBCode: Copy Table Name, to copy the table’s fully qualified name, quoted for its database, for example "public"."users". The same keys copy the qualified names of the rows selected in the connections tree.
Available copy formats
Section titled “Available copy formats”Selection includes three range-specific choices:
- Without Headers: Cell values only
- With Headers: Column names followed by cell values
- Only Headers: The selected columns’ names, as one tab-separated row
- As Comma List: Values in a comma-separated list
Both Selection and All support:
- As CSV: Comma-separated values
- As HTML: HTML table markup
- As HTML (Styled): HTML table markup with styling
- As JSON: Compact JSON
- As JSON Pretty: Formatted JSON
- As Markdown: A Markdown table
- As SQL In Clause: Values formatted for an SQL
INclause - As SQL Insert Statements: SQL
INSERTstatements - As SQL Update Statements: SQL
UPDATEstatements, keyed on the primary key (or columns you pick) in theWHEREclause - As XML: XML data