Re: Reading from a text file into PostgreSQL

From: Chester Kustarz <chester(at)arbor(dot)net>
To: Eyinagho Newton <neyinagho(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Reading from a text file into PostgreSQL
Date: 2004-10-07 15:43:38
Message-ID: Pine.BSO.4.44.0410071142440.17616-100000@detroit.arbor.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 7 Oct 2004, Eyinagho Newton wrote:
> Can anyone explain how postgreSQL reads from a text
> file into tables already created in PostgreSQL?

Check out COPY command.

http://www.postgresql.org/docs/7.4/interactive/sql-copy.html

The file has to be in a certain format as explained in the
documentaion. It is fast and simple.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-10-07 15:56:24 Re: SQL-Invoked Procedures for 8.1
Previous Message Mark Wong 2004-10-07 15:39:25 Re: FunctionCall2 performance