Good day all
As I am fairly new to postgresql I am trying to find some more info
regarding options to dump specific data to files.
Let me give you guys some idea on what I mean by this....
Currently there is a java/perl process that runs and creates datadumps
for clients with specific data as per specifications and this creates 4
output files which then are compressed and ftp'd to the client.
The current process takes a very long time to run despite the fact that
it does not need to process a lot of data.
Optimisations have been done on the Database side and the process is
still running very long.
What we are now trying to achieve is to use the Linux scripting and SQL
scripting combination to try and rewrite the process in order to compare the
two processes.
However, even though I can get the sql query,etc... how will I use this
to dump the data into the relevant files?
Any suggestions and assistance would be greatly appreciated.
Regards
Machiel
