접속
psql -h [host_IP] -p [port] -U [username] -d [dbname]
psql -h 192.168.50.238 -p 5432 -U rhema -d rhema_simple
delete all data from every tables
DO $$
DECLARE
r RECORD;
BEGIN
FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public')
LOOP
EXECUTE 'TRUNCATE TABLE public.' || quote_ident(r.tablename) || ' RESTART IDENTITY CASCADE';
END LOOP;
END $$;