Hi all,
I'm trying to copy a table with a text field column containing a new
line char to a file:
ksDesenv=# create table page(line text) without oids;
CREATE TABLE
ksDesenv=# insert into page (line)
values('1stline'||chr(10)||'2ndline');
INSERT 0 1
ksDesenv=# select * from page;
line
-----------------
1stline
2ndline
(1 registro)
ksDesenv=# copy page to '/var/www/html/kakaostats/page.txt';
COPY
But this is what the page.txt file looks like:
1stline\n2ndline
What can I do to make the copy to command insert an actual new line
char?
Regards,
Clodoaldo Pinto Neto
_______________________________________________________
Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade! Acesse: http://br.acesso.yahoo.com/
