From: | "Martijn Tonies \(Upscene Productions\)" <m(dot)tonies(at)upscene(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: import CSV file to a table |
Date: | 2017-03-08 14:13:10 |
Message-ID: | 980887502AD345C69B409FCAAEFE3589@MARTIJNWS |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
If this is a one-time thing, you can use the Import Data tool in Database Workbench, see
http://www.upscene.com/documentation/dbw5/tools_dataimport.htm
Hope this helps.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
From: Günce Kaya
Sent: Wednesday, March 08, 2017 10:13 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] import CSV file to a table
Hi all,
I want to import content of CSV file to a table via bash script without creating temporary table and I also want to skip some columns in CSV file (for instance, CSV file has 12 column and main table has only 2 column, If possible I would use only 2 column in CSV file) Is there any way to do it?
Regards,
--
Gunce Kaya
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2017-03-08 14:15:39 | Re: Request to confirm which command is use for exclusive operation |
Previous Message | John McKown | 2017-03-08 13:55:36 | Re: import CSV file to a table |