pg_pivot_longer: Convert PostgreSQL table to long format
In jjesusfilho/rpsql: Psql Meta Commands From R

Convert PostgreSQL table to long format

1	pg_pivot_longer(conn, tbl, new_tbl = NULL, cols, names_to, values_to)

`conn`	Connection.
`tbl`	Database table.
`new_tbl`	Optional. If you want to create a new table on the database intead of importing to R.
`cols`	<tidy-select> Variables to pivot into long format.
`names_to`	A string specifying the name of the column to create from the data stored in the column names of tbl.
`values_to`	A string specifying the name of the column to create from the data stored in cell values.