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?
Solution
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:
- 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.
- 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.
- To select a specific column from a table using php postgres
- PGError: ERROR: column “recipes.id” must appear in the GROUP BY clause or be used in an aggregate function
- Use functions in unique constraint on multiple columns
- psql: FATAL: Ident authentication failed for user "postgres"
- Update record of a cursor where the table name is a parameter
- How do I (or can I) SELECT DISTINCT on multiple columns?
- How list all tables with data changes in the last 24 hours?
- Unable to delete duplicate rows with PostgreSQL
- Delete duplicate rows from small table
- How to delete duplicate rows without unique identifier
- In-order sequence generation
- SQLAlchemy SELECT WITH clause/statement (pgsql)
- Accidentally restored a another database to the 'postgres' database how to correct
- MERGE RETURNING into temp table without a CTE
- How do I delete a fixed number of rows with sorting in PostgreSQL?
- Can't subtract offset-naive and offset-aware datetimes
- How can I get Postgres use my functional index
- What is the correct way to implement a context manager in psycopg2?
- Can Postgres silently ignore column constraint conflicts?
- How to LIMIT the number of parent values, but return all children for each?
- Get the first date of an ISO 8601 year and week
- how can i get the last row with a given foreign key in yii2 with relations?
- Nifi : How to move CSV content and its meta data to single table in Postgresdatabase using NiFi
- SQLAlchemy hangs when sending ALTER TABLE
- log4net:ERROR ConfigureFromXml called with null 'element' parameter for Postgres SQL
- Postgres - SQL Recursivity to get the highest parent
- RDS while connection error: no pg_hba.conf entry for host
- Best way to select random rows PostgreSQL
- How to list indexes created for table in postgres
- How do you change a user in PostgreSQL?