Newbie help please....

From: "Sue Walker-Thornton" <s(dot)m(dot)thornton(at)larc(dot)nasa(dot)gov>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Newbie help please....
Date: 2006-07-17 16:52:32
Message-ID: 44BBC050.00000C.03608@CTS1-109
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

NASA Langley Research Center
ConITS Contract
Hampton, VA 23666
(757) 224-4074
(757) 224-4001
(757) 218-8263
(757) 988-2547
s(dot)m(dot)thornton(at)larc(dot)nasa(dot)gov

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-07-17 18:05:56 Re: Newbie help please....
Previous Message Tom Lane 2006-07-17 15:16:47 Re: pg_restore failes - invalid byte sequence for encoding "UNICODE": 0xa3