Re: Copy Data Question

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy Data Question
Date: 2006-06-23 19:39:20
Message-ID: 20060623193920.48211.qmail@web31811.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> i have 11 columns total. column 1, 2, 3, 4, 5 and 6
> are NOT NULL. the rest can be null and, in the case
> of the imported data set, are null.

From:
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html

COPY tablename ( column [, ...] )

FROM 'filename'

WITH NULL AS 'null string'
;

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-06-23 19:45:59 Re: Copy Data Question
Previous Message operationsengineer1 2006-06-23 19:28:42 Re: Copy Data Question