0

This is my query

INSERT INTO EForms_M_FormTypeMaster (FormTypeId,FormTypeCode,FormTypeName) 
VALUES ('12','FM','Form');

Getting this error

Error Message relation "eforms_m_modulemaster" does not exist

Please help to solve the issue

  • Question was quiet different which is related to postgres and I am asking in my way and previous post was related to PHP and my post related to nodejs –  Feb 06 '18 at 12:31

1 Answers1

2

Where is the table? If it is in public then you must aware about case insensitive. That means if your table realname is EForms_M_FormTypeMaster you must put it between " 

INSERT INTO "EForms_M_FormTypeMaster" ("FormTypeId","FormTypeCode","FormTypeName")
    VALUES ('12','FM','Form');
clemens
  • 16,716
  • 11
  • 50
  • 65
Mabu Kloesen
  • 1,248
  • 7
  • 8
  • After mentioning INSERT INTO "EForms_M_FormTypeMaster" (FormTypeId,FormTypeCode,FormTypeName) VALUES ('12','FM','Form'); I got this error Error Message column "formtypeid" of relation "EForms_M_FormTypeMaster" does not exist –  Feb 06 '18 at 06:22
  • 1
    @Sprasanth: When you use case-sensitive column names, you must protect them with double quotes like the table name. I've updated the post. – clemens Feb 06 '18 at 06:27
  • I got it, Thank you –  Feb 06 '18 at 06:33