PostGRE_AppendData: PostGRE_AppendData

View source: R/SQL_Functions.R

PostGRE_AppendDataR Documentation

PostGRE_AppendData

Description

PostGRE_AppendData get data from a database table

Usage

PostGRE_AppendData(
  data = NULL,
  TableName = NULL,
  Append = FALSE,
  Connection = NULL,
  CloseConnection = FALSE,
  Host = NULL,
  DBName = NULL,
  User = NULL,
  Port = NULL,
  Password = NULL
)

Arguments

data

Source data.table

Append

Set to TRUE to append data, FALSE to overwrite data

Connection

db connection

CloseConnection

= FALSE

Host

If Connection is NULL then this must be supplied. host

DBName

If Connection is NULL then this must be supplied. dbname

User

If Connection is NULL then this must be supplied. user

Port

If Connection is NULL then this must be supplied. port

Password

If Connection is NULL then this must be supplied. password

Author(s)

Adrian Antico

See Also

Other Database: AutoDataDictionaries(), PostGRE_CreateTable(), PostGRE_GetTableNames(), PostGRE_ListTables(), PostGRE_Query(), PostGRE_RemoveCreateAppend(), PostGRE_RemoveTable(), PosteGRE_CreateDatabase(), PosteGRE_DropDB(), PosteGRE_ListDatabases(), SQL_ClearTable(), SQL_DropTable(), SQL_Query_Push(), SQL_Query(), SQL_SaveTable(), SQL_Server_DBConnection()

Examples

## Not run: 
AutoQuant::PostGRE_AppendData(
  data = data,
  TableName = 'somename',
  Append = FALSE,
  CloseConnection = FALSE,
  Host = 'localhost',
  DBName = 'AutoQuant',
  User = 'postgres',
  Port = 5432,
  Password = 'Aa...')

# data = data
# CloseConnection = FALSE,
# Host = 'localhost'
# DBName = 'Testing'
# User = 'postgres'
# Port = 5432
# Password = 'Aa...'

## End(Not run)


AdrianAntico/RemixAutoML documentation built on Feb. 3, 2024, 3:32 a.m.