Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5CEC59F9FE1 for ; Fri, 8 Dec 2006 21:00:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 18566-09 for ; Fri, 8 Dec 2006 21:00:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90501.mail.mud.yahoo.com (web90501.mail.mud.yahoo.com [216.252.100.168]) by postgresql.org (Postfix) with SMTP id 18A2B9F9EED for ; Fri, 8 Dec 2006 21:00:36 -0400 (AST) Received: (qmail 40935 invoked by uid 60001); 9 Dec 2006 01:00:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=WSLM69pPzjVTPRlj/9WZU6y2da/Izl8bJ1Ald3BGknMF38oZsCavECNi5S6/Uiu/eh90d85rbfLg0AC1PcQuP/SmFopxrNaUj2jLmz/bpYIuRKic0/j/ao4+W4bSpa5FAx2NWiSrcHJUnL2cBfKdpbFCEjwnUskwAR0joyvGmSw=; X-YMail-OSG: QT0z9CcVM1k8eaBVoys._oCWL8LOGmSLePIb5M2gPk49cLNHrc37T9ot_BZY4nDLt03D0HLYISnaRgCoAcMgjf8SxDempYQNOKj.08J4qSXBj7dV4hd88yHFmFk5bjbVSQ4YuazTWf3f8DtMm48eXujBar2anC1cHYc- Received: from [70.18.29.78] by web90501.mail.mud.yahoo.com via HTTP; Fri, 08 Dec 2006 17:00:35 PST Date: Fri, 8 Dec 2006 17:00:35 -0800 (PST) From: Philippe Salama Subject: .bat file to access postgreSQL command line from C:\ Dos prompt To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1294704364-1165626035=:40442" Content-Transfer-Encoding: 8bit Message-ID: <788678.40442.qm@web90501.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.499 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200612/90 X-Sequence-Number: 23882 --0-1294704364-1165626035=:40442 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks for your help! And thanks to your help, I was able to figure out the following, as a psql.bat file on drive C: cd program files cd postgreSQL cd 8.1 cd bin psql -U postgres template1 I could not figure out how to make a path work in the .bat file if there is a space in PROGRAM FILES. But it words if I just to a CD to each directory. I have a paperback on PostgreSQL in which most of the exercises use the command line prompt. Although I have found admin programs that allow me to access PostgreSQL nicely, I want to learn about the command line. I also have a 1984 book on SQL by Lantimes, and I put all the exercise tables int o MySQL. Then, I exported the tables to an SQL script, and modified the script so that it would run in PostgreSQL. If anyone is interested, I can provide that script. I would also like to go through the some of Joe Celko's books, like SQL for Smarties, and I plan to put the test tables into PostgreSQL and also MySQL. But if anyone has any test tables from SQL instruction books, let me know. I will be happy to share what I have with others if there is some interest. I feel that if the test data for such SQL exercises is made available on the Internet, then it will encourage more people to learn SQL. --------------------------------- Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster. --0-1294704364-1165626035=:40442 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks for your help!  And thanks to your help, I was able to figure out the following, as a psql.bat file on drive C:

cd program files
cd postgreSQL
cd 8.1
cd bin
psql -U postgres template1


I could not figure out how to make a path work in the .bat file if there is a space in PROGRAM FILES.  But it words if I just to a CD to each directory.

I have a paperback on PostgreSQL in which most of the exercises use the command line prompt.  Although I have found admin programs that allow me to access PostgreSQL nicely, I want to learn about the command line.

I also have a 1984 book on SQL by Lantimes, and I put all the exercise tables int o MySQL.  Then, I exported the tables to an SQL script, and modified the script so that it would run in PostgreSQL.  If anyone is interested, I can provide that script.

I would also like to go through the some of Joe Celko's books, like SQL for Smarties, and I plan to put the test tables into PostgreSQL and also MySQL.

But if anyone has any test tables from SQL instruction books, let me know.

I will be happy to share what I have with others if there is some interest. 

I feel that if the test data for such SQL exercises is made available on the Internet, then it will encourage more people to learn SQL.



Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster. --0-1294704364-1165626035=:40442--