How to insert a string in postgreSQL pgAdmin?

Question

I am new to postgreSQL. Is there a way to insert a string in postgreSQL pgAdmin without using SQL Editor (SQL query)? Help me, thanks.

Answer 1

You can do this without the SQL editor, but it’s better to do this on request.

Although pgAdmin has an option that you can click to have an Excel window in which you can add and update data in a table without using SQL. Select the table you want to add a row to and click the next icon below.

Answer 2

I think that some answers do not answer the original question, some of them insert records, but with SQL and OP statements they say explicitly WITHOUT, so I am sending the correct answer: (step by step)

Answer 3

It is forbidden to edit table data without a primary key
If your tables do not have a primary key or OID, you can only view data.
Inserting new rows and changing existing rows is not possible for the Edit Data tool without a primary key.

Answer 4

Alternatively, you can use the query tool:

INSERT INTO public.table01 (What is the age) VALUES (?,?);

Use the zipper icon to execute.

Answer 5

Use INSERT :

 INSERT INTO tablename (field1, field2) values ('value1', 2); 

Answer 6

In pgAdmin 4 (version 1.6) in a table with a specific primary key column.

1) In the pgAdmin4 viewing window, right-click on your table → select "View / Edit data" → "All rows"

2) On the "Data output" tab at the bottom of the table below the last row there will be an empty line in which you can enter new data using excel-like.