Postgres: CSV file as a table using FDW

gistfile1.txt

-- Installs "file_fdw" extension and creates foreign table to work with data from CSV file.
-- See also the comment below which helps to automate the process for Google Spreadsheets
-- Another option would be using Multicorn for Google Spreadsheets, but it requires additional steps  
-- (see https://wiki.postgresql.org/wiki/Foreign_data_wrappers).

CREATE EXTENSION file_fdw;
CREATE SERVER import FOREIGN DATA WRAPPER file_fdw;
CREATE FOREIGN TABLE table1_import (
  col1 text,
  col2 text,
  ...
) SERVER import OPTIONS ( filename '/path/to/file.csv', format 'csv' );

--

use sqlachemy auto generate schema.