Utility to Upload CSV into PostgreSQL

Question

Is there any utility available to Import the table data from CSV file.

Since I have huge no of tables and rows.Writing COPY FROM sql will take a time,so in need of any utility or another approaches

Tometzky · Accepted Answer · 2012-07-06 08:14:39Z

8

You really should use copy:

#!/bin/bash

(
  echo 'copy table_name from stdin (format csv);'
  cat table_name.csv || exit 1
  echo '\.'
) | psql database_name

You don't need to change your big files in any way. You may need to tweak some copy options (delimiter, quote etc.).

answered Jul 6, 2012 at 8:14

Tometzky

24.2k5 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Agree, COPY operator's built in CSV support is very powerfull.

jsky · Accepted Answer · 2012-07-06 07:31:32Z

0

This might be helpful:

answered Jul 6, 2012 at 7:31

jsky

2,2176 gold badges38 silver badges55 bronze badges