Hacker News new | ask | show | jobs
by siddboots 4762 days ago
> You have to map each file to a database table and then execute SQL against that database.

The create statement is just a declaration, and doesn't load data into a postgres table. Instead, it just tells postgres how to access the file. So if I then do a query that is limited to the first few rows, it will only ever need to read the first few "rows" of the file.