ping
will ignore any keywords not directly
related to the database host (e.g., username, dbname) as it
does not connect; it only detect the server port is responding.
get_conn_defaults
returns a data frame containing
all of the possible connection string keywords, the names of environment
variables used to override the defaults, the compiled in default value
and the current value of the keyword.
get_conn_info
returns a list containing
information about the current connection. For
readability, it will print as though it is a matrix. If
you want to see it as a list, try unclass(get_conn_info())
.
If length(what) == 1
then get_conn_info
returns
a scalar
set_conn_defaults
sets the connection defaults by calling
Sys.setenv
and setting the environment variable associated
with the connection keywords returned by get_conn_defaults(all = TRUE)
.
These settings will only last as long as the current shell session and will
reset after a new login.
set_default_password
will query for a password (if not supplied)
and set the PGPASSWORD
environment variable accordingly. This can be used
with psql
and copy_to
.
reset_conn_defaults
unsets all environment variables returned
by get_conn_defaults(all = TRUE)
.