[GENERAL] fied separator change from the shell command line

2005-03-13 Thread paulo . oliveira
Hello, I'm trying to change the usal | table field separator from the shell command line: psql -d ect -f pl_lost.sql -o pl_lost.out.txt -F \t -U asaadmin But it doesn't work. It keeps the same | separator in the output file. Can anyone please help me? I need to output to a tab separated file.

Re: [GENERAL] fied separator change from the shell command line

2005-03-13 Thread Edmund Bacon
[EMAIL PROTECTED] writes: Hello, I'm trying to change the usal | table field separator from the shell command line: psql -d ect -f pl_lost.sql -o pl_lost.out.txt -F \t -U asaadmin But it doesn't work. It keeps the same | separator in the output file. Can anyone please help me? I need

Re: [GENERAL] fied separator change from the shell command line

2005-03-13 Thread Tom Lane
Edmund Bacon [EMAIL PROTECTED] writes: [EMAIL PROTECTED] writes: I'm trying to change the usal | table field separator from the shell command line: psql -d ect -f pl_lost.sql -o pl_lost.out.txt -F \t -U asaadmin Changing the field separator only works with unaligned output. You need to add