Bulk Load (Copy) - First n columns.
Hello, I have a table with 300+ columns and I am using COPY command to load the file to the table. The issue I have is the feed or the csv file I have may only 1st 100 column values or 1st n column values. How do I let COPY command to know if the feed does not have values for those columns insert NULL values and load the rest without failing ?.
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.