X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 615CB9FB2B7 for ; Wed, 3 May 2006 03:49:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 18337-01-3 for ; Wed, 3 May 2006 03:48:56 -0300 (ADT) X-Greylist: delayed 00:17:44.759076 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4A7449FB5B0 for ; Wed, 3 May 2006 03:22:10 -0300 (ADT) Received: from gandalf.zedo.com (gw.zedo.com [64.41.197.46]) by svr4.postgresql.org (Postfix) with ESMTP id 84B515AFAE1 for ; Wed, 3 May 2006 06:04:23 +0000 (GMT) Received: from gourish (india.gw.juhu.zedo.com [203.129.239.221]) by gandalf.zedo.com (ZedoMail) with ESMTP id 6AB756C2305; Tue, 2 May 2006 23:04:13 -0700 (PDT) Message-ID: <051201c66e77$62eef970$6d0110ac@gourish> From: "gourish singbal" To: "Penchalaiah P." , References: Subject: Re: i am getting error when i am using copy command Date: Wed, 3 May 2006 11:34:03 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_050D_01C66EA5.7A9AC3A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-MailScanner: Found to be clean X-MailScanner-From: gsingbal@zedo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/84 X-Sequence-Number: 25115 This is a multi-part message in MIME format. ------=_NextPart_000_050D_01C66EA5.7A9AC3A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Penchal, Is /tmp folder present and is the postgres user having read/write file = permissions in /tmp folder. I was successfully able to copy a table to a file in /tmp folder on my = machine . Regards, Gourish Singbal Software Engineer ZEDO Inc - Customer-Fit Ad Serving Worldwide. gourish@ZEDO.com ----- Original Message -----=20 From: Penchalaiah P.=20 To: pgsql-sql@postgresql.org=20 Sent: Wednesday, May 03, 2006 11:01 AM Subject: [SQL] i am getting error when i am using copy command Hi .. =20 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 =20 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.. =20 May I know y I am getting this error.... pls any one can help me for = this.. Thanks & Regards Penchal reddy | Software Engineer =20 Infinite Computer Solutions | Exciting Times.Infinite Possibilities... = SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO = = =20 Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | = Retail & Distribution | Government = =20 Tel +91-80-4133-0000(Ext:503)| Fax +91-80-51930009 | Cell No = +91-9886774209|www.infics.com =20 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. =20 ------=_NextPart_000_050D_01C66EA5.7A9AC3A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Penchal,
 
 
Is /tmp folder present and is the = postgres user=20 having read/write file permissions in /tmp folder.
I was successfully able to copy a table = to a file=20 in /tmp folder on my machine .
 
Regards,
Gourish Singbal
Software Engineer
ZEDO Inc - = Customer-Fit=20 Ad Serving Worldwide.
gourish@ZEDO.com
----- Original Message -----
From:=20 Penchalaiah P.
Sent: Wednesday, May 03, 2006 = 11:01=20 AM
Subject: [SQL] i am getting = error when i=20 am using copy command

Hi = ..

 

1)      =20 I created one=20 table

2)    =20 Create table=20 penchal(id integer, name varchar(12),age=20 integer);

3)      =20 Then I inserted some = values into=20 this table=85=85=85

4)    =20 Insert into=20 penchal values(1,=92reddy=92,2);

5)      =20 Select * from penchal ; = I used=20 this statement to display the values in a = table

6)      =20 Finaly I want to use=20 copy = =85.

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

 

Copy penchal=20 to =91/tmp/penchal.out=92

When I am using this = statement I=20 am getting error is :   could not open file = =91/tmp/penchal.out=92 =20 for writing: no such = file or=20 directory..

 

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

Thanks =20 &  Regards

Penchal=20 reddy |=20 Software Engineer=20 =           

Infinite=20 Computer Solutions |=20 Exciting Times=85Infinite Possibilities...

SEI-CMMI=20 level 5 |=20 ISO=20 9001:2000

IT=20 SERVICES |=20 = BPO           &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;

Telecom=20 |=20 Finance=20 |=20 Healthcare=20 |=20 Manufacturing=20 |=20 Energy=20 & Utilities |=20 Retail=20 & Distribution |=20 Government         &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         =20

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

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

 

------=_NextPart_000_050D_01C66EA5.7A9AC3A0--