I am using plink as below.

dhirendrs · 09-04-2011, 11:36 AM

I am running below in .bat file

As below .
plink.exe -ssh -pw fks123 imfldb@10.0.7.58 /data/DailyReport/daily_report.sh

Daily_report.sh

psql -h 10.0.7.58 -p 5432 -U imfldb -f '/data/DailyReport/daily_report_qry.sql' -F -d omniflowuat > /data/DailyReport/Input/daily_report$DATE.data

Now my question is daily_report$date.data have
delimiter sign not opening as excel file,

i want to modified the script which open as .xls files.

ta0kira · 09-05-2011, 09:23 PM

You haven't specified a field separator for the -F psql option. ',' might be a good choice.
Kevin Barry

dhirendrs · 09-07-2011, 09:14 AM

Quote:

Originally Posted by ta0kira

You haven't specified a field separator for the -F psql option. ',' might be a good choice.
Kevin Barry

Can you please describe the exact query?

ta0kira · 09-07-2011, 10:25 AM

Quote:

Originally Posted by dhirendrs

Can you please describe the exact query?

I'm not sure what that means, since it's your query.

The -F option requires an argument, which is used to specify a field separator. If you want a field separator, specify it by putting an argument after -F. Otherwise, remove the -F option from your psql call. Since you're trying to open the output as a spreadsheet you might want to use -F ',' to separate the fields with a comma.
Kevin Barry