PostgreSQL Create A Line Column From Two Point Columns

Question

My database has beginning and end points [beginning(x,y) ending(x,y)]. I want to create lines from this database for each beginning-end points.

I tried ST_MAKELINE but this function wants location as text as said in this answer. I don't want to enter the points one by one.

How can I pull points from database?

Answer 1

All you need to do is call st_makeline on both geom fields:

SELECT st_makeline(geom, a_geom) as geom
FROM yourtable;