Big Query

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: Big Query

Postby _dave_ » Tue Jan 29, 2008 10:37 pm

[quote="TheProdigy"ast]what is the best way to export to excel?[/quoteast]

How are you running the query?

In pgAdmin, do File -> Export.

then choose comma as a separator, save as a CSV and it should just open straight up in Excel :)
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

Re: Big Query

Postby TheProdigy » Tue Jan 29, 2008 10:58 pm

you are awesome. period.
TheProdigy
 
Posts: 538
Joined: Sun Dec 09, 2007 1:20 am

Re: Big Query

Postby _dave_ » Tue Jan 29, 2008 11:05 pm

Thanks :)

I think this is quite a useful report too.

Now, back to making the AHK-HUD work on FTP properly :)
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

Previous

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests