Skip site navigation (1) Skip section navigation (2)

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

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Albretch Mueller <lbrtchx(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: How to just "link" to some data feed
Date: 2008-06-04 00:24:47
Message-ID: B406F4F2-CBFE-470E-99CB-5A79B1828515@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
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


In response to

Responses

pgsql-jdbc by date

Next:From: Albretch MuellerDate: 2008-06-04 02:59:49
Subject: Re: How to just "link" to some data feed
Previous:From: Albretch MuellerDate: 2008-06-04 00:04:10
Subject: How to just "link" to some data feed

pgsql-general by date

Next:From: Roberts, JonDate: 2008-06-04 02:10:45
Subject: Re: does postgresql works on distributed systems?
Previous:From: Klint GoreDate: 2008-06-04 00:17:27
Subject: Re: does postgresql works on distributed systems?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group