Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1C2789F9EED for ; Sat, 9 Dec 2006 18:49:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 68594-08 for ; Sat, 9 Dec 2006 18:49:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id D0A789F9386 for ; Sat, 9 Dec 2006 18:49:52 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1650984nfb for ; Sat, 09 Dec 2006 14:49:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OAye7VXV20XssB8kSvjtNdg4l1OVZMTnX1HEZANXFPgVDqX1Pj4gygpP2PGzb/KNPk6Gbe+tgydYpJzz4G3w5J0IOG0H+ivBzvfKCj7Ohw56HkqE0mnAN65Xa821sUF157O451niyEwvw+mekiIhz12fSNpBtm+Y5jL4vDb8r4Y= Received: by 10.82.113.6 with SMTP id l6mr107921buc.1165704590335; Sat, 09 Dec 2006 14:49:50 -0800 (PST) Received: by 10.82.164.17 with HTTP; Sat, 9 Dec 2006 14:49:50 -0800 (PST) Message-ID: <1f30b80c0612091449q1afa166v2f47f13040442828@mail.gmail.com> Date: Sun, 10 Dec 2006 03:49:50 +0500 From: imad To: "Philippe Salama" Subject: Re: Command line struggles Cc: "Shoaib Mir" , "PostgreSQL Admin" In-Reply-To: <532714.93615.qm@web90508.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <532714.93615.qm@web90508.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/123 X-Sequence-Number: 23915 See this link from PostgreSQL 8.2 official documentation. http://www.postgresql.org/docs/8.2/interactive/app-createuser.html It clearly describes the details and sitches of the createuser binary. And also, I would recommend using this documentation rather than a book which may (actually will) contain references from older versions. --Imad www.EnterpriseDB.com On 12/10/06, Philippe Salama wrote: > Of course now, I am in psql command line, and trying in vain to make the > examples work in "Beginning Databasses with POSTGRESQL" by Matthew and > Stones. > > I can type \H and see help > I can type \? and read the list that results, of commands > > I see a prompt template1-# > > yet when I type at that prompt > > createuser > > > AHAAAA wait! Light dawns on marblehead. > > A more careful reading of the textbook reveals that createuser.exe is a > program in \program files\postgresql\8.2\bin > > If I click on that createuser.exe icon in explorer, it prompts me for the > name of the new user, the password, are they superuser. > > If at the dos prompt, in \8.2\bin I type createuser -U postgres -P neil > > then, it also works, slightly differently than clicking the Icon, and echos > something about a new role. > > But, at least, I surmounted this hurdle, and can make some more progress > with the textbook. > > Hmmm... it tells me to also create a user named rick, who can create > databases, but does not have permission to create new users. I am not > certain how to do this, since the createuser program does not respond > exactly as the book describes > > > > Shoaib Mir wrote: > Glad to hear that it worked out good for you :-) > > Thanks, > --------- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 12/10/06, Philippe Salama wrote: > > Thanks Shoaib. You are perfectly correct! After I installed postgresql, > but without installing any odbc driver, I went to MS Access, and found both > the ANSI and the Unicode driver. I think I chose ANSI, ... I was able to > link to all the tables which the Celko script defined, and I was able to > browse the test data in those tables, and yet PG explorer gave some kind of > error when I tried to browse, and I could not for the life of me see where > PGAdmin allows me to browse tables. > > > > But, anyway I am making progress, and I have the latest postgresql > installed, and MS Access can link to the tables. Thanks, all! > > > > Shoaib Mir < shoaibmir@gmail.com> wrote: > > Once you have installed PostgreSQL you can now use the ANSI or Unicode > ODBC driver from the ODBC driver manager in Windows as it gets installed > automatically during installation. > > > > Thanks, > > ---------- > > Shoaib Mir > > EnterpriseDB (www.enterprisedb.com) > > > > > > On 12/10/06, Philippe Salama wrote: > > > I just installed 8.2.1 postgresql. Now I want an odbc driver to work on > my Dell XP with MS Access. The choices are very confusing. Please advise. I > am not a rocket scientist. Thanks! > > > > > > ________________________________ > Want to start your own business? Learn how on Yahoo! Small Business. > > > > > > > > > > > ________________________________ > Need a quick answer? Get one in minutes from people who know. Ask your > question on Yahoo! Answers . > > > > > > > ________________________________ > Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and > get things done faster. > >