COPY tablename FROM '/home/path/filename';
with the table created with proper columns
Larry Price | "We have seen the truth.
laprice@efn.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
>