Turn off feedback from DDL statements, etc.

Moderator: NorbertKrupa

Post Reply
sam
Newbie
Newbie
Posts: 14
Joined: Thu Sep 12, 2013 9:48 pm

Turn off feedback from DDL statements, etc.

Post by sam » Wed Apr 02, 2014 6:45 pm

Is there some way that I can turn the feedback off for vertica DDL statements and SET functions?

For example, I don't want the "CREATE SCHEMA" and "SET" commands to show up in the following:

Code: Select all

dbadmin=> create schema sam;
CREATE SCHEMA
dbadmin=> set search_path=sam;
SET

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Turn off feedback from DDL statements, etc.

Post by NorbertKrupa » Wed Apr 02, 2014 6:56 pm

Checkout vertica.tips for more Vertica resources.

sam
Newbie
Newbie
Posts: 14
Joined: Thu Sep 12, 2013 9:48 pm

Re: Turn off feedback from DDL statements, etc.

Post by sam » Thu Apr 03, 2014 4:56 am

Thanks for your reply, however that solution does not work :(

Code: Select all

dbadmin=> \pset footer
Default footer is off.
dbadmin=> create table t (c int);
CREATE TABLE
The "CREATE TABLE" output is still visible...

Post Reply

Return to “vSQL”