ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist

Sorry,here is the complete error message,

org.postgresql.util.PSQLException: ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist

Can you provide some details on where you're getting this message?
A relevant code snippet may be helpful.
Also open the psql session and run these commands:
What was the output they produced?

Sorry,here is the complete error message,

org.postgresql.util.PSQLException: ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist

Your Table "gistl_new_request" does not have a column named "nr_first_name"

Regards Gaurav

Geo=> \d GISTL_NEW_REQUEST
Did not find any relation named "GISTL_NEW_REQUEST".
Geo=> \d "GISTL_NEW_REQUEST"
Table "public.GISTL_NEW_REQUEST"
Column | Type | Modifiers
---------------+------+-----------
NR_FIRST_NAME | text | not null
NR_LAST_NAME | text |
NR_PHONENO | text | not null
NR_MOBILENO | text | not null
NR_EMAIL | text | not null
NR_CITY | text |
NR_PINCODE | text |
NR_ADDRESS | text |
NR_STATE | text |
NR_FLAG | text | not null
Indexes:
"gistl_new_request_pkey" PRIMARY KEY, btree ("NR_EMAIL")

Does double quotes " " ,matter so much.
I have created these tables using PG Amin iii,Yet i got the above error.

I could resolve this...

Thx a lot..

I could resolve this...
Thx a lot..

Yes double quotes matters


if you use double quoates " then the relations(table_name or columns_name or any other entity) becomes case sensitive


i hope that solve ur problem

Regards Gaurav