PostgreSQL Query Tool?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

PostgreSQL Query Tool?

Postby hyPOTcrisy » Thu Jun 17, 2010 11:07 am

Is there a tool I can use to manipulate the PT3 database directly; a query tool?
Or maybe and ODBC driver I could use, then connect to it via Access; which would be my prefered method?
Thanks!
hyPOTcrisy
 
Posts: 18
Joined: Fri Jun 20, 2008 5:55 pm

Re: PostgreSQL Query Tool?

Postby kraada » Thu Jun 17, 2010 1:16 pm

PGAdmin III is installed by default and is available in your start menu - you can use it to query the PostgreSQL database directly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL Query Tool?

Postby zubs1aa » Thu Jun 17, 2010 1:24 pm

hyPOTcrisy wrote:Is there a tool I can use to manipulate the PT3 database directly; a query tool?
Or maybe and ODBC driver I could use, then connect to it via Access; which would be my prefered method?
Thanks!


I did this to excel at one point.... excel/win XP had everything needed to build it. It took me a while to do but I was able to in the end. (I'd tell you how I idid it but I can't remember)

Look in access/excel under connecting to external DB's.

Actually, I think I was able to hook into access too, but i just couldn't get it to give me permissions to update the SQL DB so I gave up... (It worked fine to download into access though.)
zubs1aa
 
Posts: 2219
Joined: Fri Feb 08, 2008 1:52 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests