-- USERS
\copy ( SELECT username as "UserId", name as "Name", email_address as "Email", created_at as "evnt_created_at", created_at as "evnt_updated_at", 'events_' as "events", validated as "Validated" FROM users where created_at between '2019-09-25 14:00' and '2019-09-27 09:29') to '/tmp/users.csv' with csv;

-- PROJECT
\copy ( SELECT id::varchar as "ProjectId", owner_id::varchar as "OwnerId", created_at as "evnt_created_at", created_at as "evnt_updated_at", 'events_' as "events" FROM projects  where created_at between '2019-09-25 14:00' and '2019-09-27 09:29') to '/tmp/projects.csv' with csv;