From: Jean-Luc Lachance <jllachan@nsd.ca>
To: Jeff Eckermann <jeff_eckermann@yahoo.com>
Cc: John Zhang <jzhang@jimmy.harvard.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: copy files to postgresql
Date: Tue, 06 Aug 2002 12:20:03 -0400
Message-ID: <3D4FF733.3D6F418D@nsd.ca> (raw)
References: <20020806132325.38254.qmail@web20809.mail.yahoo.com>
A much simpler solution would be to:
create a table from the original one without the missing fields;
use the copy command to import the file;
insert into the original table from the new table, supplying null for
the missing fields.
JLL
Jeff Eckermann wrote:
>
> I believe that soon-to-be-released version 7.3 will
> have the ability to import data to specific columns,
> as you are trying to do. For now, you will have to
> edit your input file to insert values (even if null)
> for the missing columns. The default null
> representation expected by COPY is "\N" (backslash,
> upper case "N"), or you can specify another using the
> syntax "\copy .... with null as 'whatever'"
>
> --- John Zhang <jzhang@jimmy.harvard.edu> wrote:
> > I was trying to copy files to columns of a
> > PostgreSQL database table using \copy
> > ( e. g. \copy mytable (column names here) from 'my
> > file' using delimiters '\t').
> > PostgreSQL does not seem to like the column names
> > part. Could someone help me
> > with that? Thanks.
> > > Put the text of the welcome message here.
> > >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jllachan@nsd.ca, jeff_eckermann@yahoo.com, jzhang@jimmy.harvard.edu
Subject: Re: copy files to postgresql
In-Reply-To: <3D4FF733.3D6F418D@nsd.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox