CODEWITHSUNDEEP
postgresqldatagrip
swastij
swastij

Reputation: 159

how to copy a table from one postgres db to another in datagrip?

I tried exporting the data to CSV and importing it to the new database, but it does not seem to respect the case sensitivity of column names. "createdAt" becomes "createdat" and does not change even when trying to modify the table. How do I do it correctly?

Upvotes: 0

Views: 117

Answers (2)

mechaadi
mechaadi

Reputation: 978

You can use the "dump" and "restore" feature of datagrip which uses pg_dump and pg_restore behind the scenes, this will respect the case-sensitivity of the column names.

Here are the steps:

  1. Dump the database/table by right clicking on it and choose the Export with 'pg_dump' option, this will export the dump to selected destination. Make sure you add ".dump" as the destination file extension. Screenshot with description and explanation
  2. Restore the database/table by right clicking on your second database and choose the Restore... option, selected the file that you exported in step 1.

Note: If the path to pg_dump or pg_restore is invalid, you can use the "which" command in your terminal and get the correct path from there.

Upvotes: 1

Alexander Molchanov
Alexander Molchanov

Reputation: 341

This is an issue related to the character case not being retained in postgres data sources. We have this issue reported here and a fix should be included in the DataGrip 2024.3 version

Upvotes: 3

Related Questions