I have three csv files which have the same file name and different suffix in the same directory. How to access those files?
For instance, you can use create table “a.txt” (_CSV_Header boolean default true);create table “a.lst” (_CSV_Header boolean default false, _CSV_Separator char(1) default ‘\t’ );create table “a.csv” (_CSV_Comment longvarchar default 3 ); select * from “a.txt” as atxt,”a.lst” as alst, “a.csv” as acsv