Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA20888; Wed, 23 Sep 92 10:46:09 -0700
Date: Wed, 23 Sep 92 10:46:09 -0700
Message-Id: <9209231746.AA20888@postgres.Berkeley.EDU>
From: Chris Flatters <cflatter@aoc.nrao.edu>
Subject: Re: utility to read text files
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

> I am going to create a POSTGRES database and need to populate it with data
> that is stored in a large text file.  Is there a POSTGRES utility that will
> read such a file, or will I have to write a C program to read the file and
> interface with POSTGRES?

You can use 

copy <relname> from "<filename>"

to populate a relation from a text file.  You will probably have to massage
the file file with awk or perl to get it into the right format for the copy
command.

	Chris Flatters
	cflatter@nrao.edu