Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id PAA28877 for postgres-redist; Fri, 20 May 1994 15:33:01 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405202233.PAA28877@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id PAA28867 for <postgres@postgres.Berkeley.EDU>; Fri, 20 May 1994 15:33:00 -0700
Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id PAA00775; Fri, 20 May 1994 15:32:58 -0700
Message-Id: <199405202232.PAA00775@faerie.CS.Berkeley.EDU>
X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: Niranjan Perera <perera@pollux.cs.uga.edu>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: copy command ( 4.1 ) 
Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
In-reply-to: Your message of Fri, 20 May 1994 16:29:28 -0400 (EDT) 
	     <9405202029.AA01448@pollux.cs.uga.edu> 
Date: Fri, 20 May 94 15:32:58 -0700
X-Sender: aoki@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Fri, 20 May 94 15:33:01 -0700
Resent-XMts: smtp

Niranjan Perera <perera@pollux.cs.uga.edu> writes:
> Is there a way to get postgres to dump the classes out, and the file
> be owned by the user instead of "postgres" ?

not using the copy command into a file.  copy runs in the server, 
which runs as user postgres.  only the superuser (root) can become
another user.

however, there's nothing to keep you from running "copy to stdout"
and directing the result of that into a file.
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================