pgloader
pgloader copied to clipboard
CAST columns by matching name for multiple tables
I want to convert from sqlite to postgresql and I get many errors for all the columns "id" . I tried to find a solution to match not only the type for casting and I found how to cast with column names but it always need a specific table. Is there a possibility to match by a regular expression or other syntax ALL id columns at once, like:
CAST column *.the_column_name to integer