Re: Postgresql for Dummies?

Daniel Lerch wrote:

> OK, I'll check that book out.
>
> I tried running pgAdminIII, but when I tried to connect to my psql
> server I got the error:
> "SSL error: wrong version number"

An SSL error....?

>
> I'll try to figure this out, but one thing it led me to was realizing
> that I don't know what verision of psql I'm actually running, and I
> don't know how to find out (I noticed that pgAdminIII is for
> postgreSQL 7.3 and 7.4). Is there a 'version' command within psql?

psql --version
psql (PostgreSQL) 7.4.1
contains support for command-line editing
or from within psql
select version();
version
---------------------------------------------------------------
PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)

If you've got an earlier version of postgres you can download the
appropriate pgAdmin version (pgAdminII probably), which used to be
available on the website http://pgadmin.postgresql.org/pgadmin2/downloads/

Ron

>
>
> Thanks,
> -d
>
>> I suggest that you visit a bookstore and actually look at some of the
>> postgres books out there. I've got Practical Postgres (Worsley &
>> Drake) and it would probably be suitable for you. While many of these
>> books are aimed at developers quite a few of them also spell out a
>> lot of the basics too, so they'll tell you about SQL and how to use
>> postgres. There are a handful of beginner-intermediate postgresql
>> books out there, including Bruce Momjian's book Learning PostgreSQL
>> (forgive me if I get this wrong).
>>
>> Also, pgAdminIII is a good gui tool for accessing postgres.
>>
>> Ron
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>