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