Note: Please precede the names of your files on the local schema with your netid.
(DRAFT)
Create CSV
Connect to LDP
Right click on local schema
Choose Import data
Set up field mapping for source and destination fields
Source | Destination |
---|---|
date | integer |
integer | varchar |
import data
next
choose . csv file
Do Commit after row insert to make sure all records show.
Key column: When you import a local table to Dbeaver, consider adding a key column to make it easier for DBeaver to pick a key. When you first have need to edit the table, if there isn’t a clear key column, you can choose the unique column following DBeaver’s instructions [will try to flesh this out when next come across].
Updating tables: To update a local table (first open the table in the data view):
- To add a row, right click in a cell of the row you want to add the row after, click on “Edit,” and then click on “Add row,” enter data as needed, and then click on save.
- To remove a row, right click in a cell of the row you want to delete, click on “Edit,” and then click on “Delete current row,” then click on save.
- To correct a value within a cell, click on the cell, edit as needed, and then click on save; you can also open a editing window by right clicking and clicking on “Edit.”