Re: Load Text File into DB

COPY tablename FROM '/home/path/filename';

with the table created with proper columns

Larry Price | "We have seen the truth.
laprice(at)efn(dot)org | And the truth makes no sense." -chesterton
_______________________________________________________________

On Wed, 11 Apr 2001, Karl J. Stubsjoen wrote:

> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>