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 23F499FB2D3 for ; Wed, 3 May 2006 03:50:13 -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 72932-03 for ; Wed, 3 May 2006 03:48:57 -0300 (ADT) X-Greylist: delayed 00:17:51.24553 by SQLgrey- Received: from gandalf.zedo.com (gw.zedo.com [64.41.197.46]) by postgresql.org (Postfix) with ESMTP id 51E999FB5B3 for ; Wed, 3 May 2006 03:22:12 -0300 (ADT) Received: from gourish (india.gw.juhu.zedo.com [203.129.239.221]) by gandalf.zedo.com (ZedoMail) with ESMTP id BACA06C2531 for ; Tue, 2 May 2006 23:22:04 -0700 (PDT) Message-ID: <05f901c66e79$e1543c10$6d0110ac@gourish> From: "gourish singbal" To: Subject: Fw: i am getting error when i am using copy command Date: Wed, 3 May 2006 11:51:55 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_05F6_01C66EA7.F9BC5160" 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/85 X-Sequence-Number: 25116 This is a multi-part message in MIME format. ------=_NextPart_000_05F6_01C66EA7.F9BC5160 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Penchal, The ERROR u mentioned in your earlier email describes itself . It says = your "could not open file '/tmp/penchal.out' for writing: no such file or = directory.." I used the same command you used :- Copy to '/tmp/filename.out' So i suggest that u check if ur able to write/read files in /tmp = folder..=20 also you can use /home/postgres folder ?. NOTE: please do not send personnel email . email to group . Regards, Gourish Singbal Software Engineer ZEDO Inc - Customer-Fit Ad Serving Worldwide. gourish@ZEDO.com ----- Original Message -----=20 From: Penchalaiah P.=20 To: gourish singbal=20 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 =20 -------------------------------------------------------------------------= ------- From: gourish singbal [mailto:gsingbal@zedo.com]=20 Sent: Wednesday, May 03, 2006 11:34 AM To: Penchalaiah P.; pgsql-sql@postgresql.org Subject: Re: [SQL] i am getting error when i am using copy command =20 =20 Penchal, =20 =20 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 . =20 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 =20 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_05F6_01C66EA7.F9BC5160 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Penchal,
 
The ERROR u mentioned in your earlier = email=20 describes itself . It says your
"could not open file =91/tmp/penchal.out=92 =20 for writing: no such file = or=20 directory.."
 
I used the same command = you used=20 :-

Copy <table_name>=20 to = =91/tmp/filename.out=92

=
 
So i suggest that u check = if ur able=20 to write/read files in /tmp folder..
also you can use = /home/postgres=20 folder ?.
 
NOTE: please do not send personnel = email . email to=20 group .
 
Regards,
Gourish Singbal
Software Engineer
ZEDO Inc - = Customer-Fit=20 Ad Serving Worldwide.
gourish@ZEDO.com
----- Original Message -----=20
From: Penchalaiah=20 P.
Sent: Wednesday, May 03, 2006 11:46 AM
Subject: RE: [SQL] i am getting error when i am using copy=20 command

How can u = copy =85. Did u=20 see wt error am I getting=85.. tell me the syntax to create that copy=20 commnad

 

From: gourish=20 singbal [mailto:gsingbal@zedo.com]
Sent: Wednesday, May 03, 2006 = 11:34=20 AM
To: = Penchalaiah P.; pgsql-sql@postgresql.org
= Subject: Re: [SQL] i am getting = error when=20 i am using copy command

 

 

Penchal,

 

 

Is /tmp folder present and = is the=20 postgres user having read/write file permissions in /tmp=20 folder.

I was successfully able to = copy a=20 table to a file in /tmp folder on my machine=20 .

 

Regards,
Gourish Singbal
Software = Engineer
ZEDO=20 Inc - Customer-Fit Ad Serving Worldwide.
gourish@ZEDO.com

----- Original Message = -----=20

From: Penchalaiah P.=20

To: pgsql-sql@postgresql.org=20

Sent:=20 Wednesday, May 03, 2006 11:01 AM

Subject: [SQL] i=20 am getting error when i am using copy=20 command

 

Hi = ..

 

1)      =20 I created one=20 table

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

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

4)    =20 Insert into = penchal=20 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_05F6_01C66EA7.F9BC5160--