Received: from mail1.hub.org (webmail.hub.org [216.126.85.1])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f8T5Z2O71969
	for <pgsql-docs@postgresql.org>; Sat, 29 Sep 2001 01:35:02 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: from news.tht.net (news.hub.org [216.126.91.242])
	by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8S447S17087
	for <pgsql-docs@postgresql.org>; Fri, 28 Sep 2001 00:04:07 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id
 f8S3YJI13438
	for pgsql-docs@postgresql.org; Thu, 27 Sep 2001 23:34:19 -0400 (EDT)
	(envelope-from news)
From: "Adam Fisher" <black@cia.com.au>
X-Newsgroups: comp.databases.postgresql.docs
Subject: Re: Uploading files to Postgresql
Date: Fri, 28 Sep 2001 13:30:13 +1000
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 25
Message-ID: <9p0r3p$d3q$1@news.tht.net>
References: <NmGs7.891$jW2.56920@typhoon1.gnilink.net>
X-Complaints-To: scrappy@hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
To: pgsql-docs@postgresql.org
X-Archive-Number: 200110/12
X-Sequence-Number: 1026

Hi Liam,
Have a look at the COPY command, it should do what you want.
Do you know about the online book devoted to postgresql? It's a great
supplement to the manual, it can be found at:
http://www.ca.postgresql.org/docs/aw_pgsql_book/node3.html

all the best,
adam

Liam DeMasi <ldemasi@acsinc-nj.com> wrote in message
news:NmGs7.891$jW2.56920@typhoon1.gnilink.net...
> I am new to databases and am trying to find out if it is possible to
upload
> a file of records that are deliminated by a character such as | to
> Postgresql.
> I have a file that has about 400,000 records in it and I would really like
> to not have to enter all these in individually.
>
> Thank you
> my email is ldemasi@ascinc-nj.com
>
>
>