Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9C35B476A18 for ; Thu, 5 Sep 2002 17:00:45 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 532634769F5 for ; Thu, 5 Sep 2002 17:00:43 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id BC99A381BD9; Thu, 5 Sep 2002 17:00:42 -0400 (EDT) From: "news" X-Newsgroups: comp.databases.postgresql.docs Subject: pgsql user creation query: Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Thu, 05 Sep 2002 20:34:16 GMT X-Complaints-To: news@bigpond.net.au Organization: BigPond Internet Services (http://www.bigpond.net.au) To: pgsql-docs@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/24 X-Sequence-Number: 1476 Hi all, I'm just starting out with pgsql, moving away from mysql as I'm missing having a procedural language. Anyway, I apologise if this is an easily resolved problem, I have looked through the docs for any answers but they don't seem to be coming easily. I'm wondering if it's possible to create a user and assign that user as an owner of a database, so that user can do pretty much anything they wish to that database and any existing and to-be-created objects within it? I hope this makes sense Thank you all for your time, Michael.