Script to export each row of a view to seperate files

[utahstew]

I have a unique need.

I need to export script to export each row of a postgres view to individual files.

OS: Red hat 9
Language: Shell script or java

Column A - is used for the filename.
Column B - is the contents of the file.

I am not a linux programmer, I focus on database design.I assume the script is like this:

Open array
for each row in view
open file where name equals column a
contents equals column b
close file
next
close array

Any help in this matter is appreciated.

 

[feherke]

Hi

Column B - is the contents of the file.

Column type ?

By default it would be one line if you are working only with text files :

psql -t -A -c 'select filename from utahstew' | while read file; do psql -t -A -c "select content from utahstew where filename='$file'" > "$file"; done

Note that you may need to add connection and credential parameters to the [tt]psql[/tt] calls.


Feherke.

http://free.rootshell.be/~feherke/