Re: BatchMove with PostgreSQL

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Márcio Vinícius <marcio(at)vmautomacao(dot)com(dot)br>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: BatchMove with PostgreSQL
Date: 2005-01-25 18:23:15
Message-ID: 20050125182315.GA51927@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Jan 21, 2005 at 03:41:06PM -0300, Márcio Vinícius wrote:

> Hi, i'm using delphi 7 with Zeos components to access PostgreSQL 8.0 for Windows.
>
> I need to import a delimited text file into a PostgreSQL table.
>
> Like BatchMove.

I don't know how to incorporate this into the other tools you're
using, but PostgreSQL has a COPY command for importing from and
exporting to files:

http://www.postgresql.org/docs/8.0/static/sql-copy.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2005-01-25 19:01:35 Re: BatchMove with PostgreSQL
Previous Message Devrim GUNDUZ 2005-01-25 18:12:09 Re: Installing dblink