Hello, I am trying to load a file into a table using COPY command, considering the source file contains columns col1, col2, col3 and the destination table contains columns col1, col2, col3 also.
I want to skip col2 from loading (I want to keep it NULL in the destination table)
I tried to use FILLER but it didn't work, so how to skip this column please
Question
using COPY command to skip column
+1+1COPY t1 (col1,
v1 FILLER VARCHAR(20),
col3)
FROM LOCAL 'C:\folder\file1.csv'
WITH DELIMITER AS ','
+1please try in this way:
COPY t1 (col1,
f_v1 filler VARCHAR,
col2 as NULL,
col3)
FROM LOCAL 'C:\folder\file1.csv'
WITH DELIMITER AS ','
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
