Thread: ANY GOOD USER'S GUIDE ONLINE?? (with simple examples)
I am trying to get started with Postgres but it ain't easy. The documentation, although it may be thorough and very exhaustive, doesn't have much of practical value in it. I looked in a FAQ which came with the download -- again, not much useful there unless you wanted to write a dissertation. Then I found a 'User's Guide' and thought, "Of course, I have been looking a 'documentation', which, when you think about it, has done a great job of docmenting, but a 'User's Guide', that's what I've been looking for!" Well, it wasn't a real user's guide. I have been able to find useful items here and there but you have to dig through so much information that the frustration gets very high. Like, I am looking for how to insert a timestamp when a record has been updated. I have found the data type timestamp defined and documented in documentation, FAQ and 'User's Guide', but nowhere is there an example of how one would actually insert a timestamp into a record. Yes, I do have the question of the timestamp, but No that is not my main question. My main question is this "does there exist a real User's Guide in postgres-land, with actual examples of how to IMPLEMENT all this beautifully docmented material?" Sorry for putting you through this (if you made it this far), but I just needed to get this out of my system. Thanks, Paul -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Hmm, personally I've found the documentation to be quite useful. There are other sources of information that might help you. A couple of useful books you might find more useful are PostgreSQL Essential Reference and PostgreSQL Developers Handbook. Good luck. Tim ----- Original Message ----- From: "paul simdars" <psimdars@lisco.com> To: <pgsql-general@postgresql.org> Sent: Thursday, February 21, 2002 8:33 AM Subject: [GENERAL] ANY GOOD USER'S GUIDE ONLINE?? (with simple examples) > I am trying to get started with Postgres but it ain't easy. The > documentation, although it may be thorough and very exhaustive, doesn't > have much of practical value in it. I looked in a FAQ which came with > the download -- again, not much useful there unless you wanted to write a > dissertation. Then I found a 'User's Guide' and thought, "Of course, I > have been looking a 'documentation', which, when you think about it, has > done a great job of docmenting, but a 'User's Guide', that's what I've > been looking for!" > Well, it wasn't a real user's guide. I have been able to find useful > items here and there but you have to dig through so much information that > the frustration gets very high. > Like, I am looking for how to insert a timestamp when a record has been > updated. I have found the data type timestamp defined and documented in > documentation, FAQ and 'User's Guide', but nowhere is there an example of > how one would actually insert a timestamp into a record. > Yes, I do have the question of the timestamp, but No that is not my main > question. My main question is this "does there exist a real User's Guide > in postgres-land, with actual examples of how to IMPLEMENT all this > beautifully docmented material?" > Sorry for putting you through this (if you made it this far), but I just > needed to get this out of my system. > Thanks, > Paul > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
I did find some things in the user's guide (just not where I was expecting). So, maybe it has all worked out. I know I feel a lot better. Thanks -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
On Thu, 21 Feb 2002, paul simdars wrote: > I am trying to get started with Postgres but it ain't easy. The > documentation, although it may be thorough and very exhaustive, doesn't > have much of practical value in it. I looked in a FAQ which came with > the download -- again, not much useful there unless you wanted to write a > dissertation. Then I found a 'User's Guide' and thought, "Of course, I > have been looking a 'documentation', which, when you think about it, has > done a great job of docmenting, but a 'User's Guide', that's what I've > been looking for!" > Well, it wasn't a real user's guide. I have been able to find useful > items here and there but you have to dig through so much information that > the frustration gets very high. > Like, I am looking for how to insert a timestamp when a record has been > updated. I have found the data type timestamp defined and documented in > documentation, FAQ and 'User's Guide', but nowhere is there an example of > how one would actually insert a timestamp into a record. > Yes, I do have the question of the timestamp, but No that is not my main > question. My main question is this "does there exist a real User's Guide > in postgres-land, with actual examples of how to IMPLEMENT all this > beautifully docmented material?" You may want to check techdocs.postgresql.org (For the particular question of timestamps, I'd say probably in the PostgreSQL Cookbook.
The PostgreSQL web site has lots of resources, if you look around. On this page, you will seen under "General Info" links to the full text of two books that are sure to help you; you will also see a link to "Non-FAQ Documentation" which has lots of other useful resources. http://www.us.postgresql.org/users-lounge/index.html --- paul simdars <psimdars@lisco.com> wrote: > I am trying to get started with Postgres but it > ain't easy. The > documentation, although it may be thorough and very > exhaustive, doesn't > have much of practical value in it. I looked in a > FAQ which came with > the download -- again, not much useful there unless > you wanted to write a > dissertation. Then I found a 'User's Guide' and > thought, "Of course, I > have been looking a 'documentation', which, when you > think about it, has > done a great job of docmenting, but a 'User's > Guide', that's what I've > been looking for!" > Well, it wasn't a real user's guide. I have been > able to find useful > items here and there but you have to dig through so > much information that > the frustration gets very high. > Like, I am looking for how to insert a timestamp > when a record has been > updated. I have found the data type timestamp > defined and documented in > documentation, FAQ and 'User's Guide', but nowhere > is there an example of > how one would actually insert a timestamp into a > record. > Yes, I do have the question of the timestamp, but No > that is not my main > question. My main question is this "does there > exist a real User's Guide > in postgres-land, with actual examples of how to > IMPLEMENT all this > beautifully docmented material?" > Sorry for putting you through this (if you made it > this far), but I just > needed to get this out of my system. > Thanks, > Paul > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet > News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service > in the World! > -----== Over 80,000 Newsgroups - 16 Different > Servers! =----- > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) __________________________________________________ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com
> I am trying to get started with Postgres This is what I used to get me going: http://www.ca.postgresql.org/docs/aw_pgsql_book/index.html And this looks pretty good too: http://www.commandprompt.com/ppbook/ I do recommend buying a book though -- it seems easier to figure things out. Have fun! jeff
I would highly recommend Bruce Momjian's excellent Book, PostgreSQL: Introduction and Concepts. It is available online here: http://www.ca.postgresql.org/docs/aw_pgsql_book/index.html It's also available at all of your better bookstores :). Jason "paul simdars" <psimdars@lisco.com> writes: > I am trying to get started with Postgres but it ain't easy. The > documentation, although it may be thorough and very exhaustive, doesn't > have much of practical value in it. I looked in a FAQ which came with > the download -- again, not much useful there unless you wanted to write a > dissertation. Then I found a 'User's Guide' and thought, "Of course, I > have been looking a 'documentation', which, when you think about it, has > done a great job of docmenting, but a 'User's Guide', that's what I've > been looking for!" > Well, it wasn't a real user's guide. I have been able to find useful > items here and there but you have to dig through so much information that > the frustration gets very high. > Like, I am looking for how to insert a timestamp when a record has been > updated. I have found the data type timestamp defined and documented in > documentation, FAQ and 'User's Guide', but nowhere is there an example of > how one would actually insert a timestamp into a record. > Yes, I do have the question of the timestamp, but No that is not my main > question. My main question is this "does there exist a real User's Guide > in postgres-land, with actual examples of how to IMPLEMENT all this > beautifully docmented material?" > Sorry for putting you through this (if you made it this far), but I just > needed to get this out of my system. > Thanks, > Paul > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
I think you may find the Practical PostgreSQL book from O'Reilly/Command
Prompt a bit more helpful. (I intend no slight toward Mr. Momjian or his
fine work. We clearly owe him a lot. I do think the Introductions and
Concepts book is a hair too terse for beginners.) It's reasonably
well-written--with the exception of the LXP chapter, which looks like the
work of different person style-wise--and is a little more complete in its
coverage of things like pl/pgsql.
-J
Jason Earl
<jason.earl@simplot.com> To: "paul simdars" <psimdars@lisco.com>
Sent by: cc: pgsql-general@postgresql.org
pgsql-general-owner@post Subject: Re: [GENERAL] ANY GOOD USER'S GUIDE ONLINE?? (with
gresql.org simple examples)
02/21/02 12:36 PM
I would highly recommend Bruce Momjian's excellent Book, PostgreSQL:
Introduction and Concepts. It is available online here:
http://www.ca.postgresql.org/docs/aw_pgsql_book/index.html
It's also available at all of your better bookstores :).
Jason
"paul simdars" <psimdars@lisco.com> writes:
> I am trying to get started with Postgres but it ain't easy. The
> documentation, although it may be thorough and very exhaustive, doesn't
> have much of practical value in it. I looked in a FAQ which came with
> the download -- again, not much useful there unless you wanted to write a
> dissertation. Then I found a 'User's Guide' and thought, "Of course, I
> have been looking a 'documentation', which, when you think about it, has
> done a great job of docmenting, but a 'User's Guide', that's what I've
> been looking for!"
> Well, it wasn't a real user's guide. I have been able to find useful
> items here and there but you have to dig through so much information that
> the frustration gets very high.
> Like, I am looking for how to insert a timestamp when a record has been
> updated. I have found the data type timestamp defined and documented in
> documentation, FAQ and 'User's Guide', but nowhere is there an example of
> how one would actually insert a timestamp into a record.
> Yes, I do have the question of the timestamp, but No that is not my main
> question. My main question is this "does there exist a real User's Guide
> in postgres-land, with actual examples of how to IMPLEMENT all this
> beautifully docmented material?"
> Sorry for putting you through this (if you made it this far), but I just
> needed to get this out of my system.
> Thanks,
> Paul
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
You're in luck. Here's the entire O'Reilly 'Practical PostgreSQL' book online: http://www.commandprompt.com/ppbook/ Pete paul simdars wrote: > I did find some things in the user's guide (just not where I was > expecting). So, maybe it has all worked out. I know I feel a lot > better. > Thanks > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- >