data (#23) - How to convert (x,y) coordinates to geometry (#248) - Message List

Did you ever take a look at PostGIS documentation or tutorials. This question again isn't a pgRouting related one.

Well, this is the link to the PostGIS docs:  http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2747038

ST_GeomFromText(text,[<srid>])

for example

ST_GeomFromText('POINT(3 4)',4326)