dbReadTable() returns a data frame that contains the complete data
from the remote table, effectively the result of calling
SELECT * FROM <name>.
An error is raised if the table does not exist.
An empty table is returned as a data frame with zero rows.
The presence of rownames depends on the
sqlColumnToRownames() for details:
NULL, the returned data frame doesn't have row names.
TRUE, a column named "row_names" is converted to row names,
an error is raised if no such column exists.
NA, a column named "row_names" is converted to row names if it exists,
otherwise no translation occurs.
If a string, this specifies the name of the column in the remote table that contains the row names, an error is raised if no such column exists.
The default is
row.names = FALSE.
If the database supports identifiers with special characters,
the columns in the returned data frame are converted to valid R
check.names argument is
otherwise non-syntactic column names can be returned unquoted.
An error is raised when calling this method for a closed
or invalid connection.
An error is raised
name cannot be processed with
or if this results in a non-scalar.
Unsupported values for
unsupported data types,
also raise an error.
The following arguments are not part of the
(to improve compatibility across backends)
but are part of the DBI specification:
They must be provided as named arguments. See the "Value" section for details on their usage.
name argument is processed as follows,
to support databases that allow non-syntactic names for their objects:
If an unquoted table name as string:
dbReadTable() will do the
perhaps by calling
dbQuoteIdentifier(conn, x = name)
If the result of a call to
dbQuoteIdentifier(): no more quoting is done