Syntax error when inserting into foreign key

Question

I keep getting errors trying to insert data into my table. I have tried:

insert into saferdb_dot_contacts (fax, email, "dot_num_id") 
values( 'nan', 'nan', 4);

ERROR: column "dot_num_id" of relation "saferdb_dot_contacts" >does not exist

I tried:

insert into saferdb_dot_contacts (fax, email, dot_num_id) 
values( 'nan', 'nan', 4);

ERROR: column "dot_num_id" of relation "saferdb_dot_contacts" >does not exist

I tried to access the field via

SELECT dot_num_id FROM saferdb_dot_contacts;

but got :

ERROR: column "dot_num_id" does not exist LINE 1: SELECT dot_num_id FROM >saferdb_dot_contacts;

I tried:

SELECT 'dot_num_id' FROM saferdb_dot_contacts;

Which gave me a strange output of a column labled ?column?

if it helps dot_num_id is has a foreign key relationship to another table.

EDIT: I also tried:

SELECT "dot_num_id" FROM saferdb_dot_contacts;

ERROR: column "dot_num_id" does not exist LINE 2: SELECT "dot_num_id" FROM saferdb_dot_contacts; ^ SQL state: 42703

Character: 58

Could it be that - as postgres claims - dot_num_id doesn't exist on saferdb_dot_contacts? What is the schema of saferdb_dot_contacts? — Henning Koehler
– Henning Koehler, Commented Nov 11, 2018 at 1:42
BTW, in the last query you are trying to select the constant string 'dot_num_id' from the table, hence the output. — Henning Koehler
– Henning Koehler, Commented Nov 11, 2018 at 1:44
Also, what happens when you try: insert into saferdb_dot_contacts (fax, email, 'dot_num_id') , with single quotes instead of double? — Eray Balkanli
– Eray Balkanli, Commented Nov 11, 2018 at 2:40
oooh I see, it is DOT_Num_id. Please try: Select "DOT_Num_id" from saferdb_dot_contacts and let me know. — Eray Balkanli
– Eray Balkanli, Commented Nov 11, 2018 at 3:03

Eray Balkanli · Accepted Answer · 2018-11-11 03:10:54Z

3

You need to watch out for case sensivity and use double quotes. Try:

insert into saferdb_dot_contacts (fax, email, "DOT_Num_id") 
values( 'nan', 'nan', 4);

answered Nov 11, 2018 at 3:10

Eray Balkanli

8,05013 gold badges60 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1