473,577 Members | 3,192 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Books for PostgreSQL?

Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary
Nov 11 '05 #1
11 3553
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on
a RH8.0 server. Which books would you guys recommand?
Thank you.
Gary


Well Gary, I'm a newbie too and I found that 'PostgreSQL' by Douglas &
Douglas (ISBN: 0735712573) offers a very good introduction. I haven't
gotten a lot further than that for the moment, but the rest of the book
looks very prommising too. You should check the customer-reviews on Amazon
or something. You'll probably find more booktitles and info there...

Greetz
--
Tom Van den Brandt
I try...
Nov 11 '05 #2
>

Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?

Well there are official documentation of course
http://www.postgresql.org/docs/ which are very good. But since you asked
for books, there are some printed books available online:
http://www.postgresql.org/docs/awbook.html and
http://www.commandprompt.com/ppbook/book1.htm

Kaarel
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #3
Together with the official documentation I still use
PostgreSQL - Introduction and Concepts from Bruce Momjian. He should write a
much more comprehensive (tuning, large objects vs bytea) and updated (to 7.4)
2nd edition, but it is still very good and really worth the money.
Regards
Christoph
Am Donnerstag, 21. August 2003 05:13 schrieb G Lam:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 11 '05 #4
Ron
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

'PostgreSQL Essential Reference' by Barry Stinson is a useful book to
have at your desk, it's the only one I use. As the name suggests, it's a
reference and not a database/SQL how-to for total database newbies. OTOH
I *can't* recommend the O'Reilly book because the index is very poor,
making it useless as reference material.

Ron
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 11 '05 #5
> Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it
on a
RH8.0 server. Which books would you guys recommand?


Well, I'm a little biased because I work at the author's shop :), but I
use Practical PostgreSQL from O'Reilly (link below also has the book
online). And I also use Bruce Momjian's PostgreSQL Introduction and
Concepts book a lot -- it's been commuting with me to work for the past
few weeks.

I'm always on the lookout for more PostgreSQL books so I'll be
following this thread with interest.

--
Best,
Al Hulaton | Sr. Account Engineer | Command Prompt, Inc.
503.222.2783 | ah******@comman dprompt.com
Home of Mammoth PostgreSQL and 'Practical PostgreSQL'
Managed PostgreSQL, Linux services and consulting
Read and Search O'Reilly's 'Practical PostgreSQL' at
http://www.commandprompt.com
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 11 '05 #6
I'll second the usefulness of Bruce's book. I still refer to it
years after buying it.

I'd highly recommend either of the two books out by Sams with by Hans and
Ewald. Both very good good books. One is just purely Postgresql, the
other is a PHP/Postgresql book.

On Wed, 27 Aug 2003, Christoph Becker wrote:
Together with the official documentation I still use
PostgreSQL - Introduction and Concepts from Bruce Momjian. He should write a
much more comprehensive (tuning, large objects vs bytea) and updated (to 7.4)
2nd edition, but it is still very good and really worth the money.
Regards
Christoph
Am Donnerstag, 21. August 2003 05:13 schrieb G Lam:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 11 '05 #7
On Wed, 2003-08-20 at 22:13, G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?


As important as the book: what version are you using? That which
comes with RH8.0? It is recommended that you upgrade to v7.3.4.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@c ox.net
Jefferson, LA USA

4 degrees from Vladimir Putin
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 11 '05 #8
You could try postgres documentation at http://www.postgresql.org/docs/

or there is an online book titled 'PostgreSQL: Introduction and Concepts'
at http://candle.pha.pa.us/main/writings/computer.html
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 11 '05 #9
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).

The index isn't great, but easily overcome:
grep -i "search phrase" /usr/local/pgsql/doc/html/* | less

Try to do that with a book. :-)

When I can't find the answer there, I search the mailing list archives
and/or google.

-heath

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2163
by: Otis Green | last post by:
Vote for or against a new newsgroup proposal. To summarize what you need to do, just send an empty e-mail to postgresql-ballot@netagw.com You will receive a ballot by e-mail. Follow the instructions and vote. _______________________________________________________________________ FIRST CALL FOR VOTES (of 2)
0
3843
by: Bill J. | last post by:
I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL GO EXEC sp_DropServer 'PostgreSQL' GO
0
2165
by: Bill J. | last post by:
I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL GO EXEC sp_DropServer 'PostgreSQL' GO
0
1830
by: greg | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for PostgreSQL version 7.4. The latest copy of the checksums for this and other versions, as well as information on how to verify the files you download for yourself, can be found at:
1
1110
by: phil campaigne | last post by:
On Mon, 1 Mar 2004, phil campaigne wrote: >> Nigel J. Andrews wrote: >> > > >>> >On Mon, 1 Mar 2004, Phil Campaigne wrote: >>> > >>> >
5
1295
by: Miles Keaton | last post by:
I'm switching to PostgreSQL from MySQL. Using the SAMs book called PostgreSQL which has been great to skim the surface of the differerences. I had never even heard of things like triggers, views, and foreign keys before. Any recommended books or websites (or exercises) that would really help someone get to know not just the basics of how...
0
1644
by: Greg Sabino Mullane | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for following PostgreSQL versions: 7.4.5 7.4.4 7.3.7
8
4808
by: Frank Swarbrick | last post by:
I just got an email from Amazon.com offering me a pre-order of "DB2 9 for Developers" by Philip K. Gunning. Clicking on the link it showed me a few other possibly interesting books: "IBM DB2 9 New Features" by Paul Zikopoulos "Understanding DB2 9 Security" by Rebecca Bond "DB2 9 Fundamentals Certification Study Guide" by Roger E. Sanders ...
3
1285
by: Gabriele | last post by:
I would like to learn .Net framework in order to develop an hybryd system. I do have solid knowledge of general programming with some languages. I may need information about: Desktop GUI programming on .Net Web Application development with Asp.Net Handling Database with .Net DBMS used is not yet decided, but i believe it will most...
0
7845
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7776
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7869
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8143
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5340
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3779
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3797
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1385
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1107
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.