Thread: No column headings in SQL query

No column headings in SQL query

From

"David J. Lines"

Date:

28 February 2002, 19:20:51

How do I get rid of all column headings in an SQL query?  I just want to
print out the raw data without any headings.

David

Re: No column headings in SQL query

From

"Brett W. McCoy"

Date:

28 February 2002, 20:43:30

> How do I get rid of all column headings in an SQL query?  I just want to
> print out the raw data without any headings.

Assuming you mean in the psql command-line, \t will turn off column
headings and only show your rows.

-- Brett

Re: No column headings in SQL query

From

Herb Blacker

Date:

28 February 2002, 20:49:59

 From the command line, try $psql -t ...(prints tuples only)
Within psql use \t to toggle printing of headers and row counts

David J. Lines wrote:

> How do I get rid of all column headings in an SQL query?  I just want to
> print out the raw data without any headings.
>
> David
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>


--
_________________________
Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340
herbblacker@isgenesis.com