在Postgres中有没有一种方法可以基于计数器列重复行？

CREATE SEQUENCE counter_seq;

ALTER TABLE your_table ADD COLUMN counter_column INTEGER DEFAULT nextval('counter_seq');

CREATE OR REPLACE FUNCTION increment_counter()
  RETURNS TRIGGER AS $$
BEGIN
  NEW.counter_column := nextval('counter_seq');
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER increment_counter_trigger
  BEFORE INSERT ON your_table
  FOR EACH ROW
  EXECUTE FUNCTION increment_counter();