im currently working on a table in postgres where I want to select some columns and copy those into another table. But when I'm trying to do a select statement on the column I got the following error:
ERROR: column "opentime" does not exist LINE 2: select openTime from dialy; ^ HINT: Perhaps you meant to reference the column "dialy.openTime". SQL state: 42703 Character: 9
This happens on every column where the datatype is bigint. the other columns in the table are giving back a result. I also tried to query from queries and pictures from the result are below
select * from dialy;
gives:
select * from dialy; (see picture from url)
select openTime from dialy;
gives: select openTime from dialy;
This happens only on the columns where the datatype is a bigint. Not on text or double precisions etc. Could somebody help me how to select a column with a bigint as a datatype and explain the reason behind this? tnx in advance!
