I'm writing a script that can get the table dump from the postgresql and writing it into xml file.
echo "select * from emp" | psql -t -q employee postgres | sed 's/|/ /g | while read line
In the above line, I'm getting the details from the table emp from the database employee. I'm using -t to turnoff the colomn headings and -q to quit after the query is executed. Sed to parse the entire outputstream and replace | with a space.
This is limiting me from entering a name with space seperated.
Can any one tell me what is the delimiter of postgresql?