Page 1 of 1

postgresql documentation

PostPosted: Tue Apr 29, 2008 11:10 am
by lakeguy1
I would like to write queries on the database directly, in addition to using poker tracker. I would like to explore an idea i have about what would be a good measuer. I have had much experience writing SQL, table creation, administration, querying data, but that was about 10 years ago. On mainframe DB2.

I will not be bothering you with this except to ask this first question:
what documentation should I start with. Is there a Postgresql for Dummies?

The documentation that comes with the download includes Npgsql API, NPGsql, PostgerSql, PostgreSql Slony-I, pgAdmin, and finally pgsql ODBC. ???

Where to start? Something written for someone who is experienced with programming but not with this particular technology. Enough to write queries, and gain a computer-literate but not deep understanding.

thanks
lakeguy1

Re: postgresql documentation

PostPosted: Tue Apr 29, 2008 12:15 pm
by ptrack pat
You would be using pgAdmin to run the queries so I would start there. I don't really know of any type of "PostgreSQL for dummies" type documents, just the help files that come with the programs. The help for pgAdmin has all the basic information about the SQL needed for various queries but you kind of need to know what you are looking for first, it's not a step by step guide through the process.

Basically you connect to your database using pgAdmin then use the Query Tools option under the Tools menu in the pgAdmin program. There you enter the queries you want to run against the PT database.