Re: Reading from a text file into PostgreSQL - Mailing list pgsql-hackers

From Chester Kustarz
Subject Re: Reading from a text file into PostgreSQL
Date
Msg-id Pine.BSO.4.44.0410071142440.17616-100000@detroit.arbor.net
Whole thread Raw
In response to Reading from a text file into PostgreSQL  (Eyinagho Newton <neyinagho@yahoo.com>)
List 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.




pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: FunctionCall2 performance
Next
From: Tom Lane
Date:
Subject: Re: SQL-Invoked Procedures for 8.1