I have this query:
SELECT "user".id AS user_id,
"user".is_verified AS user_is_verified,
"user".name AS user_name,
"user".nickname AS user_nickname,
"user".password AS user_password,
"user".birthdate AS user_birthdate,
"user".food_restrictions AS user_food_restrictions,
"user".email AS user_email,
"user".telephone AS user_telephone,
"user".address AS user_address,
"user".shirt_size AS user_shirt_size,
"user".type AS user_type,
"user".created_at AS user_created_at,
"user".updated_at AS user_updated_at,
"user".image AS user_image,
"user".is_image_url AS user_is_image_url,
"user".code AS user_code,
"user".terms_accepted AS user_terms_accepted,
"user".recive_mails AS user_recive_mails,
"user".lleidacoins_claimed AS user_lleidacoins_claimed,
"user".token AS user_token,
"user".refresh_token AS user_refresh_token,
"user".verification_token AS user_verification_token,
"user".rest_password_token AS user_rest_password_token,
hacker.user_id AS hacker_user_id,
hacker.banned AS hacker_banned,
hacker.github AS hacker_github,
hacker.linkedin AS hacker_linkedin,
hacker.cv AS hacker_cv,
hacker.studies AS hacker_studies,
hacker.study_center AS hacker_study_center,
hacker.location AS hacker_location,
hacker.how_did_you_meet_us AS hacker_how_did_you_meet_us
FROM hacker_event_accepted,
"user" JOIN hacker ON "user".id = hacker.user_id
WHERE 1 = hacker_event_accepted.event_id
AND hacker.user_id = hacker_event_accepted.user_id
psql shows this error:
ERROR: invalid string in message
I was trying this in a fastapi but also trying the query directly on a psql connection fails either, I have searched and postgresql has a max query limit but is 1600 columns and also if I remove 4 columns from the select the query works perfectly