Postgres Pro
Downloads
Home   >   mailing lists

Re: Copying data from a tab delimited file into a table - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: Copying data from a tab delimited file into a table
Date
Msg-id CAKoxK+7b2EB54ASDRavbM=JmM0WqimWhV1eySrpGQgK5iK8HWA@mail.gmail.com
Whole thread Raw
In response to Re: Copying data from a tab delimited file into a table  (Carol Walter <carol.walter@sbcglobal.net>)
List pgsql-novice
Tree view 
On Tue, Feb 11, 2014 at 8:21 PM, Carol Walter
<carol.walter@sbcglobal.net> wrote:
> FYI, I was able to do this with the COPY command which takes a field list as arguments. I don't know if the "\copy"
commanddoes or not, but I was able to use COPY and it worked. 

Yes it does (see http://www.postgresql.org/docs/current/static/app-psql.html).

Luca

pgsql-novice by date:

Previous
From: Carol Walter
Date:
Subject: Re: Copying data from a tab delimited file into a table
Next
From: Andrew Puschak
Date:
Subject: Access 2003 reports queries taking very long