pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

CAST columns by matching name for multiple tables

Open rokdd opened this issue 8 months ago • 0 comments

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

rokdd avatar Apr 11 '25 07:04 rokdd