Re: [NOVICE] Error Relation xxxx does not exist when trying to insertnew row

Il 31/05/2017 15:57, William Colls ha scritto:
>
> voipms=> \d
>             List of relations
>  Schema |      Name      | Type  | Owner
> --------+----------------+-------+--------
>  public | CallDetail     | table | voipms
>  public | my_first_table | table | voipms
> (2 rows)
>
> voipms=> INSERT INTO CallDetail
> (datetime,Description,account,callerid,destination,Duration,rate,total)
> VALUES ('2017-03-31 14:51:22','Inbound
> DID','157974','Joe6132227566','6135091304','28','0.01000000','0.00500000');
> ERROR:  relation "calldetail" does not exist
> LINE 1: INSERT INTO CallDetail (datetime,Description,account,calleri...
>
>
>
Try changing
INSERT INTO CallDetail
(datetime,Description,account,callerid,destination,Duration,rate,total)
VALUES ('2017-03-31 14:51:22','Inbound
DID','157974','Joe6132227566','6135091304','28','0.01000000','0.00500000');
in
INSERT INTO "CallDetail"
(datetime,"Description",account,callerid,destination,"Duration",rate,total)
VALUES ('2017-03-31 14:51:22','Inbound
DID','157974','Joe6132227566','6135091304','28','0.01000000','0.00500000');

generally speaking, in order to avoid this kind of issues, I prefer
using only lowercase names for everything (databases, tables, column
names, etc)

HTH,
Moreno.