making postgresql "source" its data feed from external csv file ... - Mailing list pgsql-jdbc

From Albretch Mueller
Subject making postgresql "source" its data feed from external csv file ...
Date
Msg-id AANLkTikPAu7p-LxsPk=R_H+fY-78gPjsa=_4yqqyEqc0@mail.gmail.com
Whole thread Raw
Responses Re: making postgresql "source" its data feed from external csv file ...
Re: making postgresql "source" its data feed from external csv file ...
List pgsql-jdbc
 or keeping data processed in a DBMS in synch with local csv file
~
 I kind of like to use a fast in memory DB for coding cycles (either
HSQLDB or H2) and then when I have the need to stress test I use
postgresql, so I keep all my data as csv files which I then "source"
to tables, after running the DDL statements to create them, simply by
going:
~
 SET TABLE "<table_name>" SOURCE "<file_name.csv>;ignore_first=false;"
~
 As I understand postgresql "COPY FROM" does in effect copy the data
to the DBMS, but what I need is for the DBMS to "source" its data feed
with the outer file and synchronize it as it changes without having to
run "COPY TO". Is this possible? This way I can keep the data in a way
that I can try on any DBMS
~
 Is there an equivalent statement in postgresql or some other way to
achieve the same result?
~
 Thanks
 lbrtchx

pgsql-jdbc by date:

Previous
From: Thor Michael Støre
Date:
Subject: Re: java.sql.DatabaseMetaData.getProcedures and overloaded functions
Next
From: Craig Ringer
Date:
Subject: Re: making postgresql "source" its data feed from external csv file ...