Hi,
How do i not echo the select statement to an outfile but keep my column headers?
Thank you.
How to not echo SELECT statements to out file
Moderator: NorbertKrupa
How to not echo SELECT statements to out file
Have a GREAT day!
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to not echo SELECT statements to out file
Hi Sarah,
By default I believe that vsql won't display the SELECT statements.
It's only when we add the -e option (echo commands sent to server) that the SELECT statement shows up in the output:
Are you using the -e option?
By default I believe that vsql won't display the SELECT statements.
Code: Select all
bash-3.2$ cat jim.sql
select * from dual;
bash-3.2$ vsql -f jim.sql
SET
dummy
-------
X
(1 row)
Code: Select all
bash-3.2$ vsql -f jim.sql -e
set search_path="$user", intersect_wh, public, v_catalog, v_monitor, v_internal
SET
select * from dual;
dummy
-------
X
(1 row)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.