Creates a postgres db locally, runs postgres server and inserts events data

create_events_table_postgres_inserts_data.sql

DROP TABLE IF EXISTS events;

CREATE TABLE events
(
    date timestamp, 
    product_id text, 
    user_id bigint,      
    event text, 
    extra_data json  
);

\copy events from '/Users/xoel/CODE/Tinybird/events_generator/datasets/events_10K.csv' CSV HEADER;

postgres_create_db_locally_run_server.sh

echo removing postgres db directory
rm -rf postgresdb

echo creating postgres data directory
initdb postgresdb 

echo run postgres server
postgres -D postgresdb

postgres_create_user_insert_data.sh

echo create user locally
createdb -h localhost

echo inserting data into postgres
psql -h localhost -p 5432 -f window-funcs/create_events_table_postgres.sql