PG: Copy Spreadsheet to PG

levylabpitt / LV-Data

Collection of LabVIEW VIs to read and write lab data.

BSD 3-Clause "New" or "Revised" License

3 stars 1 forks source link

PG: Copy Spreadsheet to PG #51

Open ciozi137 opened 3 years ago

ciozi137 commented 3 years ago

move large data...vi

Produces batch file with following contents:

@ECHO OFF echo \copy llab_hello from 'C:\Users\ansom\Documents\GitHub\DSC\citadel-retro\DR200-Retro\logfiles\log 130221 124320.txt' delimiter ',' | psql postgres://phil:***@ec2-18-220-14-159.us-east-2.compute.amazonaws.com:5432/postgres PAUSE

ciozi137 commented 3 years ago

@JamesKeller22 example spreadsheet attached

log 130221 124320.txt

ciozi137 commented 3 years ago

@JamesKeller22 in the source (pg-dev branch) I renamed "move large data(wip) for real.vi" to Copy csv.vi

JamesKeller22 commented 3 years ago

@ciozi137 Awesome, got it.