On 8/21/19 4:15 PM, stan wrote:
I have a situation where we need to import data, as an interim measure,
from spreadsheets.
I have read up on \copy and COPY, but I do not see that either of these can
use the header from a CSV file to define a new table. Am I missing
something?
Data types. Sure, you've got column names from the header line, but what types do you assign them?
Text. I’m gonna post-process anyway, casting to better types isn’t a problem.
David J.
