Re: Copy Data Question
От | |
---|---|
Тема | Re: Copy Data Question |
Дата | |
Msg-id | 20060623214649.82567.qmail@web33307.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Re: Copy Data Question (Richard Broersma Jr <rabroersma@yahoo.com>) |
Ответы |
Re: Copy Data Question
|
Список | pgsql-novice |
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html > > > > 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 like: CSV QUOTE AS ''' if i'm using a ' as my quote? tia... __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
В списке pgsql-novice по дате отправления: