[This topic is migrated from our old forums. The original author name has been removed]
I want to set my default search path whenever I connect to my database so I don't have to explicitly specify a table's schema when querying. Currently, I have to manually set my search path if I want to omit tables' schema names. I'm using Vertica.
Without search path being set...
SELECT * FROM someSchema.myTable;
With search path being set....
SELECT * FROM myTable;