Postgres insert into a table

Question

I have a SQL script like this which I run from the command line using psql:

insert into "A"."B" values
(1, 'name=a', '[email protected]', 'K')

How do I convert it into INSERT command inside a database?

INSERT INTO "A"."B" (first_column, second_c, third_c, fourth_1) 
VALUES ('2', 'name=a', '[email protected]', 'K');

Also what does "A"."B" do? I read somewhere that double quotes are needed when table name has Capitals. I seem to get an error with that when I run commands inside the database.

The names are missleading "A"."first_column" means: a table named first_column in a schema named "A" — user330315
– user330315, Commented Apr 4, 2018 at 6:06
I am not exactly sure of the terminology, but when you connect to a particular DB using psql command and run commands there — pdna
– pdna, Commented Apr 4, 2018 at 6:11
You already have an insert statement, so what exactly are you trying to "convert"? — user330315
– user330315, Commented Apr 4, 2018 at 6:11

Racil Hilan · Accepted Answer · 2018-04-04 06:40:39Z

1

You said that your database name was DB and your table name was B.

You can simply use the table name alone:

INSERT INTO "B" (first_column, second_c, third_c, fourth_1) 
VALUES ('2', 'name=a', '[email protected]', 'K');

If you want to include the database name, then use:

INSERT INTO "DB"."B" (first_column, second_c, third_c, fourth_1) 
VALUES ('2', 'name=a', '[email protected]', 'K');

The double quotes are only required when the name of any entity (e.g. table, column, etc...) is a reserved word.

edited Apr 4, 2018 at 6:40

answered Apr 4, 2018 at 6:13

Racil Hilan

25.4k13 gold badges56 silver badges61 bronze badges

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

5 Comments

pdna Over a year ago

DB=> select * from "A" DB-> I don't see anything

pdna Over a year ago

Database name is DB. How can I know the table name? His command did not throw any error, i made a mistake. But I don't see entries in the table like I do when I run the .sql scripts

pdna Over a year ago

Sorry I was confused. I am rolling back a change in my question. B is my table name. I made a dumb mistake

pdna Over a year ago

Let us continue this discussion in chat.

pdna Over a year ago

Both the answers are correct, its just that I made a couple of typos in my commands.

Anand Singh · Accepted Answer · 2018-04-04 06:51:38Z

1

You can use this query where A is schema and B is table name.

INSERT INTO "A"."B" (first_column, second_c, third_c, fourth_1) 
VALUES ('2', 'name=a', '[email protected]', 'K');

edited Apr 4, 2018 at 6:51

answered Apr 4, 2018 at 6:11

Anand Singh

2102 silver badges13 bronze badges

2 Comments

pdna Over a year ago

After running this, when i run select * from "A"."first_column"; i don't see the entry in the table.

Racil Hilan Over a year ago

This is identical to the query in the question. So how is this an answer?

Collectives™ on Stack Overflow

Postgres insert into a table

2 Answers 2

5 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Related