Re: Initializing tables from flat files - Mailing list pgsql-novice

From googleplex6000@yahoo.com (Joe)
Subject Re: Initializing tables from flat files
Date
Msg-id 74c02fb5.0403022135.29464129@posting.google.com
Whole thread Raw
In response to Initializing tables from flat files  (<kynn@panix.com>)
List pgsql-novice
kynn@panix.com wrote in message news:<200403011958.i21JwO527887@panix3.panix.com>...
> 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/static/tutorial-populate.html

pgsql-novice by date:

Previous
From: Elinor Medezinski
Date:
Subject: find close (duplicate) points + create index
Next
From: stm23
Date:
Subject: using pgsql on my comp only without tcp