/usr/lib/R/site-library/RPostgreSQL/devTests/copyTest.sh is in r-cran-rpostgresql 0.4-1build1.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | #!/bin/bash
set -e
dbname="pgtemp"
createdb ${dbname}
echo "Created ${dbname}"
cat <<EOF | R --slave
library(RPostgreSQL)
data(trees)
drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv, dbname="${dbname}")
res <- dbWriteTable(con, "trees", trees)
dbDisconnect(con)
EOF
psql ${dbname} -c "select * from trees;"
dropdb ${dbname}
echo "Deleted ${dbname}"
|