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

On 2017-05-31 10:06 AM, Moreno Andreo wrote:
> 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.
>
>
>
Thank you. That got it. I knew it had to be something really simple.
Thanks again.