Postgresql – What is the best way to split a column of data in a txt file based on the first delimiter?
I have a large number of txt files with a single column of data. There are no headers in the files. The data are an email address followed by a : and then a string of varchar, which sometimes includes…