Considering the differences between the two DBMSs, determine the most effective and appropriate way to move all of that metadata from SQL Server to PostgreSQL. Use the source database as a reference.

While I am a general Linux admin, I have never administered or used PostgreSQL, although I do admin a few MySQL instances. I have just been told that a system currently hosted on SQL Server 2008 ...

All column names are put in quotes and lower cased because Postgresql standard is lowercase and is case sensitive where as SQL Server isn't. Also, the quotes are to handle reserved key words.

Computed Column Yes Yes, available in v12. Use Views for earlier versions Computed Columns are called Generated Columns in PostgreSQL. Generated columns must reference a current column in the table.