# Spatial queries with PostgreSQL on AWS

I have some data in PostgreSQL which I am exporting to Amazon RDS service. Will I be able to use PostGIS extension in AWS, Also will I need the mandatory column "geom" or I could run queries with just latitude longitude valuies?

• Note that the name "geom" is just a convention, not a requirement; you could name the column chocolate_cake_with_grapefruit_juice if you were so inclined. – Vince Aug 28 at 0:19
• Oh yeah, I should mentioned is the geometry column mandatory, which I have found out by now that it is required to run spatial operations, despite having lat long values. Yes I understand geom is just a naming convention, thanks for pointing out. – Tanya Aug 28 at 16:55

## 1 Answer

Yes, you will be able to use PostGIS with RDS. See Amazon's user guide on Working with PostGIS.

It appears to be the full, unmodified extension, so I would assume it operates just like a non-cloud installation. You'll still need a geometry column in order to run spatial queries.

• Thanks a lot Alex. Let me try it out – Tanya Aug 27 at 22:31
• Im facing some connection issues with AWS, waiting for support from their team. Meanwhile I just wanted to know if I will be able to import existing postgres databases into aws server. The reverse is possible I know. Could you help please Alex? – Tanya Aug 30 at 0:12
• Yes, you should be able to import. See their help files here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/… – Alex Aug 30 at 13:27
• Alex any idea about this : gis.stackexchange.com/questions/334091/… – Tanya Sep 5 at 20:18