Error: relation [table] does not exist

Question

Apologies, I inadvertently published this post without even typing the title fully.

I've uploaded a CSV to MyDB for use with the XMatch service, and I'm getting the following error:

Error: relation "mydb.vlass_extended" does not exist LINE 1: copy (select * from mydb."vlass_extended") to stdout wi... ^

The first few lines of the table are as follows:

Component_id,RA,DEC

90,1.7676E-4,80.01266745

4,2.2179E-4,44.16959552

63,2.9568E-4,-6.4918483

36,3.7319E-4,19.04433061

This seems like it ought to be the correct format - is the scientific notation messing with the parser? The table was generated with TOPCAT and is ~1.8 million lines long (I recognize the size could also be the issue and am currently trying with a smaller table).

Thanks for the help!

Answer 1

Hi, 

Thanks for your question. Firstly, can you confirm that vlass_extended exists in your MyDB? One way you can do this is by opening a Jupyter Notebook on our server and executing the following:

from dl import queryClient as qc
print(qc.mydb_list(),"\n")

This will list all tables currently saved in your MyDB.

Secondly, I tried to reproduce your error by copying and pasting the first few lines of the table you provided and uploading it to MyDB. When I pasted it into a text file it showed up with spaces in between each row, like:

Component_id,RA,DEC

90,1.7676E-4,80.01266745

4,2.2179E-4,44.16959552

63,2.9568E-4,-6.4918483

36,3.7319E-4,19.04433061

As opposed to the typical:

Component_id,RA,DEC
90,1.7676E-4,80.01266745
4,2.2179E-4,44.16959552
63,2.9568E-4,-6.4918483
36,3.7319E-4,19.04433061

Do you know if your actual table has spaces in between each row or is it just from how your post was formatted? If it does have spaces, that will cause an error upon uploading it to MyDB.