Using double quote to wrap string in sql query not compatible in PostgreSQL

Under PostgreSQL, double quote is used to denote a column name, thus this query at line 623 in filefield_paths.module would failed:-

db_query('UPDATE {files} SET filename = "%s", filepath = "%s" WHERE fid = %d', $file['filename']['new'], $file['field']['filepath'], $file['field']['fid']);