How do I auto-run a SQL command on DB connect? : DbVis Software

a

anonymous

started a topic almost 11 years ago

[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;

Thanks!

Hans Bergsten

said almost 11 years ago

[This reply is migrated from our old forums.]

Re: How do I auto-run a SQL command on DB connect?

Hi Laeisan,

Please have a look at the Connection Hook feature:

http://confluence.dbvis.com/display/UG91/Executing+SQL+at+Connect+and+Disconnect

Best Regards,
Hans

a

anonymous

said almost 11 years ago

[This reply is migrated from our old forums. The original author name has been removed]

Re: How do I auto-run a SQL command on DB connect?

Thanks, Hans! That's exactly what I need :)

How can we help you today?

How do I auto-run a SQL command on DB connect?

anonymous

Hans Bergsten

anonymous