X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1C9F39DCADF for ; Tue, 29 Nov 2005 06:43:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14765-09 for ; Tue, 29 Nov 2005 06:43:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from kiwi.adonten.net (kiwi.adonten.net [204.157.14.138]) by postgresql.org (Postfix) with ESMTP id 0E5BA9DCA9F for ; Tue, 29 Nov 2005 06:43:12 -0400 (AST) Received: (qmail 8800 invoked from network); 29 Nov 2005 10:43:13 -0000 Received: from localhost (127.0.0.1) by localhost with SMTP; 29 Nov 2005 10:43:13 -0000 Received: from 82-70-183-14.dsl.in-addr.zen.co.uk (82-70-183-14.dsl.in-addr.zen.co.uk [82.70.183.14]) by webmail.adontendev.net (IMP) with HTTP for ; Tue, 29 Nov 2005 10:43:13 +0000 Message-ID: <1133260993.438c30c107f70@webmail.adontendev.net> Date: Tue, 29 Nov 2005 10:43:13 +0000 From: frank church To: pgsql-sql@postgresql.org Subject: Re: How to change database owner in PostgreSQL 7.4? References: <1133007407.4388522f8e8c4@webmail.adontendev.net> <20051126122549.GA3312@kaufbach.delug.de> In-Reply-To: <20051126122549.GA3312@kaufbach.delug.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 82.70.183.14 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/268 X-Sequence-Number: 23519 Quoting Andreas Kretschmer : > frank church schrieb: > > > Hi guys, > > > > What is the command change database owner in PostgreSQL 7.4? > > ALTER DATABASE foo OWNER TO blob; I tried that and it didn't work. That command appears to be available only in 8.0. Is there a way of updating the system tables to change it? > 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° > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.