Command line option
От | David |
---|---|
Тема | Command line option |
Дата | |
Msg-id | 48576A01-93E2-4ADB-99B4-7CA89FF97996@talamh.org.uk обсуждение исходный текст |
Ответы |
Re: Command line option
|
Список | pgsql-novice |
Hi How do I write my psql command line if I want the output to be tab separated? If I use psql interactively, I would go #psql name_of_db name_of_db =# \a name_of_db =# \f '\t' name_of_db =# \o outputfile.txt name_of_db =# \i queryfile.sql This produces nice tab separated output that I can open in Excel and that is recognised as such. I understand that my command line should look like this: psql -A -F something_to_produce_a_tab -f queryfile.sql -o outputfile.txt name_of_db But obviously I am struggling to get the string for something_to_produce_a_tab right. I tried '\t' of course and many variants of it, but I always ending up inserting the string literally (more or less). Can somebody please help? I am on FreeBSD, using the bash shell and PostgreSQL 8.1.2. Thanks DR
В списке pgsql-novice по дате отправления: