Initializing tables from flat files

From: <kynn(at)panix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Initializing tables from flat files
Date: 2004-03-01 19:58:24
Message-ID: 200403011958.i21JwO527887@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have several tables of data represented as newline-delimited records
of tab-delimited fields in flat files.

What is the easiest way (e.g. in psql) to initialize PostgreSQL tables
from these flat files? Is there a way to do this without writing a
bazillion INSERT statements?

Thanks!

kj

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message kynn 2004-03-02 02:27:56 How to initialize from flat files?
Previous Message Tom Lane 2004-03-01 16:40:22 Re: compile-time options