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


vertica.dplyr JDBC connection would it be possible to use a different schema than the public schema — Vertica Forum

vertica.dplyr JDBC connection would it be possible to use a different schema than the public schema

The vertica jdbc connection always default to the public schema. Is there a way to change schemas different than the public schema or to open the connection to a different schema ?

vertica <- src_vertica(dsn = NULL, jdbcpath="/ecrfiles/git/prometheus_distribution/ecrfiles/lib/external/vertica-jdbc-8.1.0-3.jar","hci3","localhost",5433,"dbadmin","eppassword")

Thanks in advance

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.