Re: copy files to postgresql

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(at)jimmy(dot)harvard(dot)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