Re:Run SQL on JSON files without any data loads
by siddboots on Friday May 31, 2013 @07:36PM
(#5801887)
> 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.
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.