LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   psql - skip all formatting and spit just the data I'm asking for (http://www.linuxquestions.org/questions/programming-9/psql-skip-all-formatting-and-spit-just-the-data-im-asking-for-4175446083/)

eantoranz 01-17-2013 05:33 PM

psql - skip all formatting and spit just the data I'm asking for
 
Hi!

I'm creating a bash script and I want to get a single value from a single table in the DB... no formatting, no column name, no nothing, just the value of that column I'm asking for (single row in the table).

-q does remove a lot of stuff but I still get the column name, "-------------", and the number of rows in the result.

Thanks in advance.

michaelk 01-17-2013 08:19 PM

Try -t

eantoranz 01-18-2013 10:23 AM

That did the trick. Thanks, man.


All times are GMT -5. The time now is 05:23 AM.