Re: Load Text File into DB - Mailing list pgsql-general

From Chris Jones
Subject Re: Load Text File into DB
Date
Msg-id 9b7gee$2b5o$1@news.tht.net
Whole thread Raw
In response to Load Text File into DB  ("Karl J. Stubsjoen" <karlflips@kstub.com>)
List 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@news.tht.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
>
>



pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Benchmarking PostgreSQL
Next
From: Stephan Szabo
Date:
Subject: Re: Got stumped.. Need assistance with a sql query