Reading csv files using SQL

[Paul McGuire]

On Mar 1, 12:30 am, Pablo was Paolo <n... at spam.it> wrote:
> Hi,
>
> Dennis Lee Bieber ha scritto:
>
> >    You could maybe use SQLite to load the CSV file and process in an
> > actual DBMS...
>
> Ok, this is the solution I'm using actually (with PostGres).
> My hope is to find a way to do the same thing without using a DBMS but
> working directly with the files.
>
> Thanks a lot,
> Paolo

Sqlite has an in-memory option, so that you can read in your csv, then
load into actual tables.

sqlite is really lightweight, you are using postgres now but sqlite in-
memory will get you a lot further than writing your own SQL processor.

-- Paul