Re: import CSV file

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: mailreg(at)numerixtechnology(dot)de
Subject: Re: import CSV file
Date: 2007-03-14 01:48:50
Message-ID: a55915760703131848y47efff4fh928b1ee17e20b2cd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 3/13/07, T E Schmitz <mailreg(at)numerixtechnology(dot)de> wrote:
> This is pretty ingenious!
> Just a few minor problems:
> - how does COPY know which column is which?
> - how do I specify DELIMITER as TAB?

See:
http://www.postgresql.org/docs/8.2/static/sql-copy.html

> Also, it's nopt happy about the date format : 2007/02/09

See:
http://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-DATESTYLE

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message hu js 2007-03-14 08:14:07 How to declare cursor if tablename is a variable?
Previous Message Jonah H. Harris 2007-03-14 01:44:54 Re: Maintence DB