Postgres SQL is support in Hana Database ?

[Former Member]

Hi Expert,

I have existing PostgreSQL DB now our requirement to move the database to Hana ,

So can we directly used the PostgreSQL Script in Hana to create the same structure of database ?

Thanks,

Sumit

[kapil_tilwani · Accepted solution]

Hi Sumit,

It all boils down to what you would really like to do. If reading from Information_schema is required, it is perfectly doable - SAP HANA has metadata exposing system views which would give you the desired results. All you may need to do is create a wrapper (read view) on these tables and voila - for eg., INFORMATION_SCHEMA.TABLES can point to SYS.M_CS_TABLES with appropriate field aliasing as well.

The challenge you may most likely face would be in areas where you are using DB-specific functionality - e.g., partitioning, tablespaces, view-updates, materialised views.

In summary, you would definitely need to go through an entire DB migration but I would say it should not be overly complicated.

Regards,

Kapil