Skip site navigation (1) Skip section navigation (2)

Re: How to read data from a file?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: kynn(at)panix(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to read data from a file?
Date: 2004-02-08 17:30:19
Message-ID: 20040208092906.O56539@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sun, 8 Feb 2004 kynn(at)panix(dot)com wrote:

> Is there a way to initialize tables by reading the data from a regular
> text file?

That depends on the definition of regular.  COPY (and \copy in psql)
allow importing of data from a delimited text file with one line per row.

In response to

pgsql-novice by date

Next:From: Bill MoseleyDate: 2004-02-08 17:35:35
Subject: Re: How to read data from a file?
Previous:From: Reshat SabiqDate: 2004-02-08 17:21:35
Subject: Re: How to read data from a file?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group