| From: | Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> |
|---|---|
| To: | Piotr <hokah(at)wp(dot)pl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dbf to pgsql |
| Date: | 2005-08-04 22:56:26 |
| Message-ID: | 20050805104854.M36653@storm-user.niwa.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 4 Aug 2005, Piotr wrote:
> Hi,
> Im lookig for tool to regulary transfer data from dbf files into pgsql.
> Would be excellent if the tool would have data tranformation
> possibility.
>
A simplistic approach but workable would be to use the dbfinfo/dbfdump
programs which are part of the shapelib tools at www.maptools.org.
These allow you to dump the data description & data itself as text which
could then be COPY'd into a table built in Postgres.
An ODBC link may also work, but it's not something I've tried, (I have a
feeling there is an ODBC driver for dbf files, if not then the above dumps
can be opened with teh ODBC text driver & transferred to Postgres.
Brent Wood
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-08-04 22:58:04 | Re: What causes lock? |
| Previous Message | Michael Fuhr | 2005-08-04 22:49:22 | Re: DNS vs /etc/hosts |