Re: import CSV file to a table

["Martijn Tonies \(Upscene Productions\)" <m.tonies@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxx

Subject: 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