'How to add external value to a field when importing csv file into Aurora Postgresql

I have several csvs that needs to be imported in to Aurora postgres. Also I have an additional column that needs to be a part of a DB table, but not a part of the given csv. for example:

Table: report-id (UUID), name (String), title (String), ...

csv: name (String), title(String) ...

I'm using SELECT aws_s3.table_import_from_s3 API, but couldn't find any reference to provide some default value to a column in a table that is not a part of the csv.

Is there a way, while uploading to provide a report-id value

postgresqlcsvimportamazon-aurora


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions