Обсуждение: How to read data from a file?

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

Thanks!

kynn

Sorry, I meant to add this to the post quoted below.  I'm still trying
to find the mother-lode of useful PostgreSQL info for beginners.  I
looked at *4* PG books yesterday at the bookstore (Douglas & Douglas,
Momjian, Stinson, and the one published by O'Reilly).  *None* of them
answered the question quoted below (or if they did, I couldn't find
their answers using the index and the table of contents, which is just
as bad as not giving the answer at all), so I decided none was worth
buying.  (I had been warned about how poor PG books are, so this did
not come as a surprise.)



   Date: Sun, 8 Feb 2004 12:04:54 -0500 (EST)
   From: <kynn@panix.com>


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

   Thanks!

   kynn

   ---------------------------(end of broadcast)---------------------------
   TIP 4: Don't 'kill -9' the postmaster

kynn@panix.com wrote:

>Is there a way to initialize tables by reading the data from a regular
>text file?
>
>Thanks!
>
>kynn
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
You could parse the file programmatically issuing insert/update
commands. The best i know. :)

--
Sincerely,
Reshat.

-------------------------------------------------------------------------------------------
If you see my certificate with this message, you should be able to send me encrypted e-mail.
Please consult your e-mail client for details if you would like to do that.

On Sun, 8 Feb 2004 kynn@panix.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.

On Sun, Feb 08, 2004 at 12:04:54PM -0500, kynn@panix.com wrote:
>
> Is there a way to initialize tables by reading the data from a regular
> text file?

Define "regular".

How about:

  psql -d databse -f regular_text_file.sql


--
Bill Moseley
moseley@hank.org

Thanks for all replies.  From them I was able to find the "\i"
command, which is what I was looking for.

kynn