The Vertica Database Forums

Posted: **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

Posted: **Wed Apr 02, 2014 6:56 pm**

Try:

Code: Select all

\pset footer

Original thread

Documentation

Posted: **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...

The Vertica Database Forums

Turn off feedback from DDL statements, etc.

Turn off feedback from DDL statements, etc.

Re: Turn off feedback from DDL statements, etc.

Re: Turn off feedback from DDL statements, etc.