Re: How to just "link" to some data feed

On 3-Jun-08, at 8:04 PM, Albretch Mueller wrote:
> Hi,
> ~
> I have some CSV files which I need to link to from within PG
> ~
> From http://darkavngr.blogspot.com/2007/06/importar-datos-externos-nuestra-base-de.html
> ~
> Say, you have the following data feed in /tmp/codigos_postales.csv
> ~
> "01000","San Angel","Colonia","Alvaro Obregon","Distrito Federal"
> "01010","Los Alpes","Colonia","Alvaro Obregon","Distrito Federal"
> "01020","Guadalupe Inn","Colonia","Alvaro Obregon","Distrito Federal"
> "01028","Secretaria de Contraloria y Desarrollo Administrativo","Gran
> usuario","Alvaro Obregon","Distrito Federal"
> "01029","Infonavit","Gran usuario","Alvaro Obregon","Distrito Federal"
> "01030","Axotla","Pueblo","Alvaro Obregon","Distrito Federal"
> "01030","Florida","Colonia","Alvaro Obregon","Distrito Federal"
> "01040","Campestre","Colonia","Alvaro Obregon","Distrito Federal"
> ~
> then you can defined the DB data model as:
> ~
> CREATE TABLE codigos_postales(
> cp char(5),
> asentamiento varchar(120),
> tipo_asentamiento varchar(120),
> municipio varchar(120),
> estado varchar(120)
> );
> ~
> and copy all values into the DB like this:
> ~
> COPY codigos_postales FROM '/tmp/codigos_postales.csv' DELIMITERS
> ',' CSV;
> ~
> But how do you just link to the data feed effectively keeping it in a
> CSV file format not internal to PG?
> ~
> Also I need for all changes to the data to (of course!) be propagated
> to the data back end
> ~
> Then you can link to the same data feed from some other engine that
> reads in CSV (I think all do or should)
> ~
> How do you link to a CSV using PG?
> ~
> Thank you
> lbrtchx
>

You can't.

You have to insert it into the table
>

so you need some code which reads the csv and inserts it into the table.

Dave
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc