Re: Initializing tables from flat files

From: googleplex6000(at)yahoo(dot)com (Joe)
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Initializing tables from flat files
Date: 2004-03-03 05:35:38
Message-ID: 74c02fb5.0403022135.29464129@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

kynn(at)panix(dot)com wrote in message news:<200403011958(dot)i21JwO527887(at)panix3(dot)panix(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2004-03-03 14:15:17 Re: UPDATE FROM syntax
Previous Message Bruce Momjian 2004-03-02 19:00:29 Re: Column Headings using Comment?