Skip site navigation (1) Skip section navigation (2)

Re: Copy Data Question

From: <operationsengineer1(at)yahoo(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy Data Question
Date: 2006-06-23 21:46:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
> > 
> > COPY tablename ( column [, ...] )
> >     
> > FROM 'filename'
> >           
> > WITH NULL AS 'null string'
>   DELIMITER AS 'delimiter'
>   CSV QUOTE AS 'quote' 
>   FORCE NOT NULL column1, column2, column3, column4,
> column5, column6 
> > ;

the delimiter is the tab, which is the default.  i
don't think i need to include it.  i don't what i'd
put in place of 'delimiter' to represent tab, anyhow.

i'm not getting CSV QUOTE.  should by statement look


if i'm using a ' as my quote?


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

In response to


pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-06-23 21:54:35
Subject: Re: Copy Data Question
Previous:From: operationsengineer1Date: 2006-06-23 21:23:48
Subject: Re: Copy Data Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group