gistfile1.txt

-- 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-12-11 02:06' and '2019-12-16 09:09') 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-12-11 02:10' and '2019-12-16 09:15') to '/tmp/projects.csv' with csv;