Initializing tables from flat files - Mailing list pgsql-novice

From
Subject Initializing tables from flat files
Date
Msg-id 200403011958.i21JwO527887@panix3.panix.com
Whole thread Raw
List 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



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: compile-time options
Next
From:
Date:
Subject: How to initialize from flat files?