News for hackers. Stuff that matters.

A comment on The CSV Virtual Table. Parent comment

Re:The CSV Virtual Table by frabert on Wednesday March 09, 2022 @08:35AM (#30614234)
You could just

  INSERT INTO regular_table SELECT * FROM csv_table
and then create an index for regular_table
[ Parent | on HN ]
Re:The CSV Virtual Table by codemonkey-zeta on Wednesday March 09, 2022 @10:27AM (#30615483)
Genuine question - why start with a virtual table at all in this case? Why not just import the data to regular_table from the csv file?
[ Parent | on HN ]
Re:The CSV Virtual Table by CRConrad on Thursday March 10, 2022 @09:13AM (#30627080)
Apparently this is for when you decide not to create indexes etc on the data, presumably to save disk space or something.
[ Parent | on HN ]