PostgreSQL - Bulk Load snap
Hi Snaplogic gurus,
Quick question regarding PostgreSQL Bulk Load snap when input is binary (output from file reader which is a csv) does the psql command also needs to be setup in the nodes to wor...
Forum Discussion
How does the COPY command using the headers when format is CSV ?
I’m getting this error column record_id which is the 1st column and is a serial column, because my CSV doesn’t have the record_id and my table starting column is record_id then effective_timestamp
In order to allow insert for serial column in a COPY command it should be ommitted?
COPY table_name(column names) from myfile with csv
…myfile row 2
…myfile row 3
…
I’m doing this because there are about 500 tables that needs to be staged with a minimum of 200 columns… I don’t want to declare those columns in the snap ☹️
