‹ Back to Astro Data Lab

Similar crossmatch service error: Error: relation "mydb.bcs3" does not exist LINE 1: copy (select * from mydb.bcs3) to stdout with csv heade... ^

0 votes
265 views
Similar to the recent question but this time it mentions the csv header.
by pmanojlovic (150 points) | 265 views

1 Answer

0 votes
Best answer
It's the same problem in the sense that these tables have invalid column names, in this case 'm*' and "e_m*".  I've renamed these columns to be just 'm' and 'e_m' for your 'bcs', 'bcs2' and 'bcs3' tables so please try the crossmatch again.
by datalab (21.6k points)
selected by 747
This solved it, but I also had to remove the hyphen (-) from the "LCS-CL" column. Cheers!
by pmanojlovic (150 points)

449 questions

463 answers

473 comments

658 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.

Categories