How to write each record of the result of a sql query to a file, separated by a space in bash? How to write each record of the result of a sql query to a file on a separate line in bash?
- 2never worked with postgres but I am sure that awk, sed + output redirection + xargs will help you - jmu
|
3 answers
psql dbname -c 'select * from test1' > file.txt 
Nicolas Chabanovsky ♦
38.2k 54 220 437
nörbörnën nörbörnën
3,906 2 17 27
|
echo "SELECT * FROM table" | psql -Uuser -Wpassword dbname > file 
Aleksey Bogdanov Aleksey Bogdanov
one
|
mysql -h host -u user -e "SELECT account, shell FROM passwd" -ss namedb> shells.txt
shaman888 shaman888
1,267 nineteen 49
|