The Case of Object Names: Quick Tip

Jim Knicely authored this tip. When creating objects in Vertica (i.e., tables), Vertica preserves the “case” of the object name in the catalog meta-data exactly as you ask. dbadmin=> SELECT table_name FROM tables WHERE table_name ILIKE '%lower_case%'; table_name ------------ lower_case (1 row) dbadmin=> DROP TABLE lower_case; DROP TABLE dbadmin=> CREATE TABLE LOWER_CASE (c1 INT); CREATE...