Newbie help please.... - Mailing list pgsql-general

Hi,

     I am relatively new to PostgreSQL, having only been exposed to it with a recent DSpace implementation (in the last 8 months or so).  I have created a new database in PostgreSQL and have written a SQL query against the database.  The database resides on a Sunfire V440 Solaris 9 machine.  I need to figure out how to either create an icon on a User's desktop on a Windows machine that invokes and runs the SQL query, or - if that can't be done -  create a script they can execute to accomplish the same thing.  The script will need to allow the Users to input some parameters which will be passed to the SQL query (Begin Date, End Date, etc) and will then execute the query, write the output to a file and then invoke a Excel spreadsheet macro to pull the data into the Excel spreadsheet and format it.

 

     Is this possible or am I on the wrong track??  Any suggestions or help would certainly be appreciated.  If there's a better way to accomplish this, I'd love to hear it.  :-)

Thanks,

Sue