PostgreSQL INSERT INTO return ERROR: column "***" does not exist [duplicate]

Question

I want to insert a row "India", "Aditya Birla Capital Ltd", "INE674K01013", "INR", "ADTB","Aditya Birla Capital" to table shares."shareNames". This is the postgresql code:

INSERT INTO shares."shareNames" ("country", "full_name", "isin_code", "currency", "symbol", "stock_name") 
VALUES ("India", "Aditya Birla Capital Ltd", "INE674K01013", "INR", "ADTB","Aditya Birla Capital")
RETURNING *;

What I expected

I expected that shares."shareNames" would have a row like :

country|full_name               |isin_code   |currency|symbol|stock_name 
India  |Aditya Birla Capital Ltd|INE674K01013|INR     |ADTB  |Aditya Birla Capital

Actual result

Instead:

ERROR:  column "India" does not exist
LINE 3: VALUES ("India", "Aditya Birla Capital Ltd",
                ^
SQL state: 42703
Character: 125

Request: Please help me fix this problem!

Slava Rozhnev · Accepted Answer · 2020-12-28 09:43:09Z

4

In PostgreSQL the double quoting used only for DB entities names like table, column names. For escape strings use single quotes like:

INSERT INTO shares."shareNames" (
    "country", "full_name", "isin_code", "currency", "symbol", "stock_name"
) VALUES (
   'India', 'Aditya Birla Capital Ltd', 'INE674K01013', 'INR', 'ADTB', 'Aditya Birla Capital'
)
RETURNING *;

answered Dec 28, 2020 at 9:43

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

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

2 Comments

Mainak Over a year ago

ERROR: malformed array literal: "Aditya Birla Capital Ltd" LINE 4: 'India', 'Aditya Birla Capital Ltd', 'INE674K01013', 'INR... ^ DETAIL: Array value must start with "{" or dimension information. SQL state: 22P02 Character: 134

Mainak Over a year ago

It is not working, thanks anyway

Anil · Accepted Answer · 2020-12-28 09:44:50Z

1

try like below

INSERT INTO shares."shareNames" ("country", "full_name", "isin_code", "currency", "symbol", "stock_name") 
VALUES ('India', 'Aditya Birla Capital Ltd', 'INE674K01013', 'INR', 'ADTB','Aditya Birla Capital')
RETURNING *;

answered Dec 28, 2020 at 9:44

Anil

471 silver badge8 bronze badges

5 Comments

Mainak Over a year ago

ERROR: malformed array literal: "Aditya Birla Capital Ltd" LINE 2: VALUES ('India', 'Aditya Birla Capital Ltd', 'INE674K01013',... ^ DETAIL: Array value must start with "{" or dimension information. SQL state: 22P02 Character: 125

Anil Over a year ago

check this post; stackoverflow.com/questions/31519063/…

Mainak Over a year ago

It is not working

Mainak Over a year ago

Ok i will check it

Mainak Over a year ago

Thanks anyway for your help

Collectives™ on Stack Overflow

PostgreSQL INSERT INTO return ERROR: column "***" does not exist [duplicate]

2 Answers 2

2 Comments

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Linked

Related