DEV Community

Beaver Bridge
Beaver Bridge

Posted on

Postgresql for loop

Postgres에서 날짜 목록을 생성한 후 테이블에 하나씩 넣기 위해 loop를 돌리려면 이렇게 하면 된다.

do $$
declare
  dates date;
begin
  for dates in SELECT generate_series('2023-07-01'::DATE, '2023-07-31'::DATE, '1 day'::interval)::DATE loop
    insert into my_table(user_id, date, type) values ('my_user_id',dates, 'OFF');
  end loop;
end;
$$;
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay