ST_GEOGRAPHY DATA TYPE LOADING POSTGRESQL TIGER DATA INTO TERADATA (FILE BASED)
Here is the Goal, to migrate TIGER tables from an existing POSTGRES DB INTO A Teradata Database. Networking constraints to not allow for direct DB to DB connectivity so some sort of file movement would be required to support this data migration.
1. Some of the TIGER data is stored using simple common data elements (Characters and Numbers) so migarting those tables into Teradata is not a problem, data can be extracted using Postgessql "COPY" commend, sending data to files and then loading files into tables using Mload or Fastload.
2. Some of the TIGER data has geospatial data elements, these data elements could also be sent to a file using the "Copy" command, however, I have no idea if Teradata would be able to read data formatted in that manor.
So, how should I extract the data from a Postges DB? (One File Per Table) What tool or format is required to ensure the entire table is in a format a teradata load utilitiy can read and load?
What is the correct coresponding load utility to then load the data into an ST_GEOGRAPHY Data type?