#!/bin/bash

su -c 'psql gitea' postgres <<<'

select 
	type, name as user_name, full_name, email, to_timestamp(created_unix) as created, to_timestamp(last_login_unix) as last_login 
from "user"
order by type, created_unix desc;

select
	owner_name, name as repository_name, pg_size_pretty(size) as size, to_timestamp(created_unix) as created, to_timestamp(updated_unix) as updated
from repository
order by updated, created;
'