[GENERAL] fied separator change from the shell command line
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. Can anynone hel me with this? Thanks in advance, PJO ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] fied separator change from the shell command line
[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 to output to a tab separated file. Can anynone hel me with this? Thanks in advance, Changing the field separator only works with unaligned output. You need to add a -A to your command line switches (or --no-align). Doing this, though, drops the column headers. -- Remove -42 for email ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] fied separator change from the shell command line
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 a -A to your command line switches (or --no-align). Doing this, though, drops the column headers. There's a bit of a documentation issue I think: the psql reference page doesn't point out that -F only affects unaligned output. You could find that out by consulting the crossreferenced description of \pset fieldsep, but it seems better to mention it under -F too. I've changed the documentation accordingly in CVS HEAD. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster