I have a csv of UK postcodes from Ordnance Survey that looks like
SE1 0AA,10,531869,179427,E92000001,E19000003,E18000007,E09000028,E05000536
When I import to QGIS using 'Add Delimited Text Layer', I can declare columns 3 and 4 as x and y and everything plots nicely with a new layer created.
I want to store the same data in PostGIS so I can join other data on the postcode and then plot resulting attributes in QGIS. The postcode table, with the same fields, has no geometry and I can't see a way to declare the x and y columns as coordinates, so it is shown in QGIS as just an attribute table.
Can anyone explain what I have missed? I apologise for any mangled terminology - this may be why I haven't found any solution on the web yet.