Обсуждение: i am getting error when i am using copy command

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 have two causes, IMHO: You either have a _totally broken_
un*x[1] installation, or you run on Windows or another platform that has
different file naming conventions.


HTH,
Markus



[1] un*x is a shortcut for all unixoid operating systems, including BSD,
Linux and even MacOS X.

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

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 psql from.  If you want local files, you
need to use \copy instead.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
It is above all style through which power defers to reason.    --J. Robert Oppenheimer

> 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.

----- 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 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 values in a table

6)       Finaly I want to use copy ….

7)       But I am getting error when I am using this copy statement

 

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..

 

 May I know y I am getting this error…….. pls any one can help me for this..

Thanks  &  Regards

Penchal reddy | Software Engineer           

Infinite Computer Solutions | Exciting Times…Infinite Possibilities...

SEI-CMMI level 5 | ISO 9001:2000

IT SERVICES | BPO                                                                                                                                                                          

Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Retail & Distribution | Government                                                       

Tel +91-80-4133-0000(Ext:503)| Fax  +91-80-51930009 | Cell No  +91-9886774209|www.infics.com          

Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and/ or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this mail from your records.