Re: Copying data from a tab delimited file into a table

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Carol Walter <carol(dot)walter(at)sbcglobal(dot)net>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Copying data from a tab delimited file into a table
Date: 2014-02-11 20:36:02
Message-ID: CAKoxK+7b2EB54ASDRavbM=JmM0WqimWhV1eySrpGQgK5iK8HWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Feb 11, 2014 at 8:21 PM, Carol Walter
<carol(dot)walter(at)sbcglobal(dot)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" command does 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew Puschak 2014-02-12 14:53:28 Access 2003 reports queries taking very long
Previous Message Carol Walter 2014-02-11 19:21:47 Re: Copying data from a tab delimited file into a table