We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Terminal settings for Vsql client — Vertica Forum

Terminal settings for Vsql client

Hi,

I am using vsql client for vertica in Mac Terminal, do you have any settings by which I can view the o/p of a query result properly like :

set heading off;

set echo off;

Set pages 0;

set long 90000;

set lin 800;

set longchunksize 200500;

etc, what are the corresponding settings for vsql?


Appreciate your help. 

Thanks, Amit

Comments

  • In vsql , type \h , it will show you list of vsql setting  options , specifically  to what you ask , you can see the formatting section .

    Formatting
      \a             toggle between unaligned and aligned output mode
      \b             toggle beep on command completion
      \C [STRING]    set table title, or unset if none
      \f [STRING]    show or set field separator for unaligned query output
      \H             toggle HTML output mode (currently off)
      \pset NAME [VALUE]
                     set table output option
                     (NAME := {format|border|expanded|fieldsep|footer|null|
                     recordsep|tuples_only|title|tableattr|pager})
      \t             show only rows (currently off)
      \T [STRING]    set HTML <table> tag attributes, or unset if none
      \x             toggle expanded output (currently off)


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file