[postgis-users] Importing data in Lambert72 (Belgium)

[Jo]

Hi,

I've been reading docs, but I'm afraid I can't figure it out on my own.

I have a csv-file:
POI_ID;POI_name;coordinateX;coordinateY


Where X and Y are in Lambert72.


How can I get these in a table that includes 2 columns with those same
coordinates in WGS84? Should I have a column with a geometry type and
a point in it? Can I create a trigger function which updates the WGS84
as the Lambert72 are inserted?

Jo