Re: Load Text File into DB

From: "Chris Jones" <chris(dot)jones(at)romancompany(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Load Text File into DB
Date: 2001-04-13 18:27:29
Message-ID: 9b7gee$2b5o$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is what I have used with success..

copy {table name} from '{delimited file name}' using delimiters '\t' with
null as '';

Of course, don't put in the brackets and you can use whatever null character
you might need...

Hope this helps

Chris
Karl J. Stubsjoen wrote in message <9b20s1$1b3d$1(at)news(dot)tht(dot)net>...
>Hello,
>
>I have a tab delimited text file located on the server and would like to
>load this into a table. How do I accomplish this?
>
>Thanks!
>
>Karl
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-13 18:47:15 Re: Shared memory failure?
Previous Message Justin S. 2001-04-13 18:19:54 RE: Shared memory failure?