Initializing tables from flat files

#1

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#2

kynn (AT) panix (DOT) com wrote in message news:<200403011958.i21JwO527887 (AT) panix3 (DOT) panix.com>...

Quote:

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

COPY ... FROM ...

http://www.postgresql.org/docs/7.4/s...-populate.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Initializing tables from flat files

comp.databases.postgresql.novice comp.databases.postgresql.novice

Initializing tables from flat files - 03-01-2004 , 01:58 PM

Re: Initializing tables from flat files - 03-02-2004 , 11:35 PM