1. SELECT pg_get_serial_sequence('table_name', 'p_id');
2. SELECT setval(
  '1stqueryoutput',
  (SELECT COALESCE(MAX(moderator_id), 1) FROM moderator_data)
);

fixed
check nxt what value is 
3. SELECT nextval('1stqueryoutput');