Accessing Large Data Tables when Excel Fails

If you have run into a data set that you need to query, and Excel or LibreOffice just isn't handling it well, it's time to import the CSV to Postgresql.
  1. Install TeamPostgreSQL
  2. Export your data as a .csv 
  3. Create the table in the database

CREATE TABLE example_table (         
“PRIMEFIELD” BIGINT NOT NULL,          
"DATAFIELD” VARCHAR(3) NOT NULL,          
);
  1. Upload the CSV to Postgres server then upload into database. Make sure this csv file is accessible by the username running the postgresql process:
 copy example_table from '/opt/data.csv' DELIMITERS ',' CSV;