From: Ashikali Ashikali <ashikali.m@...>
Date: 2009-04-04T01:17:14+09:00
Subject: Re: unable run \copy command via PGconn.( exec || query )

Ara Howard wrote:
> On Apr 3, 2009, at 9:09 AM, Ashikali Ashikali wrote:
> 
>> Can anyone tell me How to escape this \copy in PGconn.( query|| exec )
> 
> all of the \*** commands are implemented by the psql command line
> program, not the database, so none of them will ever work with a raw
> connection.  fyi.
> 
> a @ http://codeforpeople.com/

Thanks for your response . But I found the solution using psql command . 
That is ,
psql -A -c "\\COPY 
ivr_interface.call_reports(pbxid,channeltype,callerid,calledid,landedtime,endedtime,endstatus,endreason,progresslangauge,defaultlanguage,internalerror) 
from ./backupFiles/ivr_interface.call_reports.new WITH DELIMITER '$' 
NULL 'nil'"  -q -t -h 192.168.1.156 -U tikono tikono"

cheers,
ashikali
-- 
Posted via http://www.ruby-forum.com/.