Welcome to the Vertica Forum

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Tips from the Team

Announcements, news, and tips from Vertica employees.

Simplify String Literals with Dollar-Quoted String Literals

Jim_Knicely 801 views 0 comments 0 points Started by Jim_Knicely November 2018
Re-Compute a Table Column’s Default Value Immediately

Jim_Knicely 792 views 0 comments 0 points Started by Jim_Knicely November 2018
Re-Compute a Table Column’s Default Value

Jim_Knicely 841 views 0 comments 0 points Started by Jim_Knicely October 2018
Derive a Table Column’s Default Value from another Column

Jim_Knicely 802 views 0 comments 0 points Started by Jim_Knicely October 2018
Default a Column’s Value

Jim_Knicely 1.6K views 0 comments 0 points Started by Jim_Knicely October 2018
Display View Column Data Types

Jim_Knicely 1.5K views 0 comments 0 points Started by Jim_Knicely October 2018
Insert Text Into Text

Jim_Knicely 783 views 0 comments 0 points Started by Jim_Knicely October 2018
Reset Your Session

Jim_Knicely 824 views 0 comments 0 points Started by Jim_Knicely October 2018
Conveniently Display Key Projection Info

Jim_Knicely 781 views 0 comments 0 points Started by Jim_Knicely October 2018
Generate an Auto-Incrementing Alphabetical Series Using SQL

Jim_Knicely 792 views 0 comments 1 point Started by Jim_Knicely October 2018
Viewing Previously Generated Explain Plans

Jim_Knicely 843 views 0 comments 0 points Started by Jim_Knicely October 2018
Display Null Query Result With an Alternate Text

Jim_Knicely 821 views 0 comments 0 points Started by Jim_Knicely October 2018
Special Date/Time Formatting

Jim_Knicely 823 views 0 comments 0 points Started by Jim_Knicely October 2018
Change the VSQL Result Set Border

Jim_Knicely 791 views 0 comments 0 points Started by Jim_Knicely October 2018
Find Which System Tables Have a Particular Column Name

Jim_Knicely 892 views 0 comments 0 points Started by Jim_Knicely October 2018
Find Which Tables Have a Particular Column Name

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely October 2018
Display Last SQL Run Time

Jim_Knicely 921 views 0 comments 0 points Started by Jim_Knicely October 2018
Renaming a View

SarahL 1.3K views 2 comments 0 points Most recent by Jim_Knicely October 2018
Displaying the Administration Tools Process ID

Jim_Knicely 812 views 0 comments 0 points Started by Jim_Knicely October 2018
Rotating Column Data Using SQL Analytics

Jim_Knicely 792 views 0 comments 0 points Started by Jim_Knicely October 2018
Return Zero Instead of NULL

Jim_Knicely 982 views 0 comments 0 points Started by Jim_Knicely October 2018
Display the Current Statement Number Within the Current Transaction

Jim_Knicely 877 views 0 comments 0 points Started by Jim_Knicely September 2018
Changing the Owner of a View

Jim_Knicely 1.7K views 0 comments 0 points Started by Jim_Knicely September 2018
Setting Variables on the VSQL Command Line

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely September 2018
Enabling Inter-Node Spread Encryption

Jim_Knicely 922 views 0 comments 0 points Started by Jim_Knicely September 2018
Exiting a DbVisualizer Script Following an Error

Jim_Knicely 972 views 0 comments 1 point Started by Jim_Knicely September 2018
Exiting a vsql Script Following an Error

Jim_Knicely 1.2K views 0 comments 1 point Started by Jim_Knicely September 2018
The Parts of a Session ID

Jim_Knicely 883 views 0 comments 1 point Started by Jim_Knicely September 2018
Faster Data Loads with Apportioned Load

Jim_Knicely 866 views 0 comments 0 points Started by Jim_Knicely September 2018
Self-Descriptive Constraint Names

Jim_Knicely 806 views 0 comments 0 points Started by Jim_Knicely September 2018