_Loki_
02-20-2010, 02:40 PM
pgAdmin III > Tools > Query tools > SQL Editor tab/pane
& then type 1] or 2] below & press F5
1] Select Count(*) from pokerhands
2] SELECT pokersites.sitename,count(*) FROM pokerhands LEFT JOIN pokersites ON pokerhands.site_id = pokersites.site_id GROUP BY pokersites.sitename
To save time & typing errors I have queries 1] & my version of 2] saved in a doc to copy/paste into SQL Editor when I want # of hands info
QUESTION:
Is there a way of saving queries 1] & 2] INSIDE pgAdmin III so I can run them without having to copy/paste the queries each time ?
& then type 1] or 2] below & press F5
1] Select Count(*) from pokerhands
2] SELECT pokersites.sitename,count(*) FROM pokerhands LEFT JOIN pokersites ON pokerhands.site_id = pokersites.site_id GROUP BY pokersites.sitename
To save time & typing errors I have queries 1] & my version of 2] saved in a doc to copy/paste into SQL Editor when I want # of hands info
QUESTION:
Is there a way of saving queries 1] & 2] INSIDE pgAdmin III so I can run them without having to copy/paste the queries each time ?