Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 54E859F9F75 for ; Sat, 9 Dec 2006 18:40:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 41128-07 for ; Sat, 9 Dec 2006 18:40:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90508.mail.mud.yahoo.com (web90508.mail.mud.yahoo.com [216.252.100.175]) by postgresql.org (Postfix) with SMTP id B3C7F9F9EED for ; Sat, 9 Dec 2006 18:40:01 -0400 (AST) Received: (qmail 93782 invoked by uid 60001); 9 Dec 2006 22:39:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=DKV5HUT+hIoZ+s0KqgI3/K3ifowxJF51T/wFo/p8tqzfay+6BBdNFu4QEiEpdQa8QnmXOTUNc5m/FpsfzeHuk/oQrH5ILW82z8ex6Gr/tTOlhiH2c6tP+4DpkCvAan6aS285o9By/OKtPToseyfCnrRdavu5oSDfzIkaIhxR9Ms=; X-YMail-OSG: DT46B.UVM1khJkXTn_08A93NbuDtaL19kmERIbzKuO3hpQW8fwFEDNAGTPxLjdrsTy2YSevbzdILxaycZLaaSfwDY9vJRBs1y383KeZoF_vo6Z6rQhX6dqpDaAPR8Xeoqiouw93YhXXQrnp.K6Uy0UTeahReyasOEPU- Received: from [70.19.76.226] by web90508.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 14:39:59 PST Date: Sat, 9 Dec 2006 14:39:59 -0800 (PST) From: Philippe Salama Subject: Command line struggles To: Shoaib Mir Cc: PostgreSQL Admin In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1504451972-1165703999=:93615" Content-Transfer-Encoding: 8bit Message-ID: <532714.93615.qm@web90508.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.002 tagged_above=0 required=5 tests=AWL, BAYES_05, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: ** X-Archive-Number: 200612/121 X-Sequence-Number: 23913 --0-1504451972-1165703999=:93615 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-1504451972-1165703999=:93615 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 <shoaibmir@gmail.com> wrote:
Glad to hear that it worked out good for you :-)

Thanks,
---------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <karebacnyc@yahoo.com> 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 <karebacnyc@yahoo.com > 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. --0-1504451972-1165703999=:93615--