X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B72F6DBA46 for ; Sat, 26 Nov 2005 08:21:18 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34308-08 for ; Sat, 26 Nov 2005 12:21:20 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from 137086.vserver.de (vs137086.vserver.de [62.75.137.86]) by svr1.postgresql.org (Postfix) with ESMTP id 9018EDB8FE for ; Sat, 26 Nov 2005 08:21:14 -0400 (AST) Received: from a-kretschmer.de (p54B3A613.dip0.t-ipconnect.de [84.179.166.19]) (authenticated bits=0) by 137086.vserver.de (8.12.8/8.12.8) with ESMTP id jAQCL6HB011078 for ; Sat, 26 Nov 2005 13:21:10 +0100 Received: from kretschmer by a-kretschmer.de with local (Exim 3.36 #1) id 1Efz7l-0000rj-00 for pgsql-sql@postgresql.org; Sat, 26 Nov 2005 13:25:49 +0100 Date: Sat, 26 Nov 2005 13:25:49 +0100 From: Andreas Kretschmer To: pgsql-sql@postgresql.org Subject: Re: How to change database owner in PostgreSQL 7.4? Message-ID: <20051126122549.GA3312@kaufbach.delug.de> References: <1133007407.4388522f8e8c4@webmail.adontendev.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1133007407.4388522f8e8c4@webmail.adontendev.net> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B 3B86 4DB3 D9EE 7F45 84DA X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! X-Lugdd: Gerd Kube X-Info: My name is root. Just root. And I am licensed to kill -9 User-Agent: mutt-ng 1.5.9i (Linux) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/250 X-Sequence-Number: 23501 frank church schrieb: > Hi guys, > > What is the command change database owner in PostgreSQL 7.4? ALTER DATABASE foo OWNER TO blob; In general: start psql and type '\h alter database', and, more general, '\h' and '\?' HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°