Thread: Seeking impressions on "The Postgresql Reference Manual" - Volumes 1, 2 & 3

Seeking impressions on "The Postgresql Reference Manual" - Volumes 1, 2 & 3

From
"Greg Cocks"
Date:

Hello,

 

I created and some clients are using a PostgreSQL database with a web page connect. This is for holding environmental analytical data, locations of features, etc. I have added PostGIS but am as yet only using it minimally. I want to be able to write spatial queries on my data and later have the client do it via a web interface. The database is pretty complicated, based on an EQUiS ERD, BUT is currently a ‘holding place’ as I do most of my queries in the more familiar to me MS Access front end with ODBC connect

 

However, I would like to learn more about using this data and queries, SQL, etc, etc DIRECTLY in PostgreSQL – views, learns more about constraints, etc, etc – and make the web page more useful, etc – and in my professional situation I need to be self taught about this (and PHP, HTML, Java, OpenLayers, MapServer, etc, etc…   J    )

 

May be this is not the place - but I was seeking impressions on "The PostgreSQL Reference Manual", 2007 published - Volumes 1, 2 & 3? Worth dropping $100 of my own money on? Is there a better book or series of books? Something free online? ‘Hands on’ is best suited to how I learn, as I have real data…

 

Thanks in advance!

----------
Regards,
GREG COCKS
Data Management Specialist / Scientist / GIS Analyst V
gcocks@stoller.com
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell

 

Re: Seeking impressions on "The Postgresql Reference Manual" - Volumes 1, 2 & 3

From
Bruce Momjian
Date:
Greg Cocks wrote:
> Hello,
>
>
>
> I created and some clients are using a PostgreSQL database with a web
> page connect. This is for holding environmental analytical data,
> locations of features, etc. I have added PostGIS but am as yet only
> using it minimally. I want to be able to write spatial queries on my
> data and later have the client do it via a web interface. The database
> is pretty complicated, based on an EQUiS ERD, BUT is currently a
> 'holding place' as I do most of my queries in the more familiar to me MS
> Access front end with ODBC connect
>
>
>
> However, I would like to learn more about using this data and queries,
> SQL, etc, etc DIRECTLY in PostgreSQL - views, learns more about
> constraints, etc, etc - and make the web page more useful, etc - and in
> my professional situation I need to be self taught about this (and PHP,
> HTML, Java, OpenLayers, MapServer, etc, etc...   :-)    )
>
>
>
> May be this is not the place - but I was seeking impressions on "The
> PostgreSQL Reference Manual", 2007 published - Volumes 1, 2 & 3? Worth
> dropping $100 of my own money on? Is there a better book or series of
> books? Something free online? 'Hands on' is best suited to how I learn,
> as I have real data...

I would just get the current PDF documentation and email it to a company
like Staples and they will make books for you.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +