Fw: [SQL] i am getting error when i am using copy command

2006-05-09 Thread gourish singbal
ah P. To: gourish singbal Sent: Wednesday, May 03, 2006 11:46 AM Subject: RE: [SQL] i am getting error when i am using copy command How can u copy …. Did u see wt error am I getting….. tell me the syntax to create that copy commnad   From: gourish singbal [mailto:[EMAIL PROTECTED] Sent: Wedn

Re: [SQL] i am getting error when i am using copy command

2006-05-09 Thread gourish singbal
PROTECTED] - Original Message - From: Penchalaiah P. To: pgsql-sql@postgresql.org Sent: Wednesday, May 03, 2006 11:01 AM Subject: [SQL] i am getting error when i am using copy command Hi ..   1)   I created one table 2) Create table

Re: [SQL] i am getting error when i am using copy command

2006-05-03 Thread Ben K.
file '/tmp/penchal.out' for writing: no such file or directory.. _IF_ you're on linux it could be due to selinux. setenforce 0 might solve the problem tempoarily. I would assume there should've been some existing discussion threads. (setenforce 1 afterwards.) Regards, Ben K. -

Re: [SQL] i am getting error when i am using copy command

2006-05-03 Thread Andrew Sullivan
On Wed, May 03, 2006 at 10:02:37AM +0200, Markus Schaber wrote: > > file ?/tmp/penchal.out? for writing: no such file or directory.. > > It seems that the /tmp directory is missing from your system. Right. And notice that the "your system" here is the _server_, not the machine you're running p

Re: [SQL] i am getting error when i am using copy command

2006-05-03 Thread Markus Schaber
Hi, Penchalaiah, Penchalaiah P. wrote: > Copy penchal to ‘/tmp/penchal.out’ > > When I am using this statement I am getting error is : could not open > file ‘/tmp/penchal.out’ for writing: no such file or directory.. It seems that the /tmp directory is missing from your system. This can hav

[SQL] i am getting error when i am using copy command

2006-05-02 Thread Penchalaiah P.
Hi ..   1)   I created one table 2) Create table penchal(id integer, name varchar(12),age integer); 3)   Then I inserted some values into this table……… 4) Insert into penchal values(1,’reddy’,2); 5)   Select * from penchal ; I used this statement to display the val