在PostgreSQL中将地址字段拆分为两行

SELECT regexp_replace(address, E'\\n', ' ', 'g') AS modified_address
FROM your_table;

SELECT 
    substring(modified_address from 1 for position('\n' in modified_address)-1) AS address_line1,
    substring(modified_address from position('\n' in modified_address)+1) AS address_line2
FROM (
    SELECT regexp_replace(address, E'\\n', ' ', 'g') AS modified_address
    FROM your_table
) AS subquery;