Re: [GENERAL] import CSV file to a table

Поиск
Список
Период
Сортировка
От Martijn Tonies \(Upscene Productions\)
Тема Re: [GENERAL] import CSV file to a table
Дата
Msg-id 980887502AD345C69B409FCAAEFE3589@MARTIJNWS
обсуждение исходный текст
Ответ на [GENERAL] import CSV file to a table  (Günce Kaya <guncekaya14@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,
 
If this is a one-time thing, you can use the Import Data tool in Database Workbench, see
 
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.
 
Sent: Wednesday, March 08, 2017 10:13 AM
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

В списке pgsql-general по дате отправления:

Предыдущее
От: John McKown
Дата:
Сообщение: Re: [GENERAL] import CSV file to a table
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: [GENERAL] Request to confirm which command is use for exclusiveoperation