('Oh My Gosh', 'peach nectar', 1, 'pineapple juice', 1, 'stir with ice, strain intoo shot glass'), You are now connected to database "drinks" as user "postgres". What am I missing here? The INSERT works fine if I stick to just one row at a time. I've got a table called 'easy_drinks' inside a db called 'drinks', When inserting multiple rows the db prompt shows either a '(' or a ' as if I've missed closing a parentheses or a single quote, but which i haven't. When inserting multiple rows I run into a problem. Right now I'm learning how to insert data, starting by creating the db, then the table, and then entering all the data off the page. You can view EDUCBA’s recommended articles for more information.Hello, I'm in the process of learning SQL from a book and have been using PG 13 as my RDBMS. We hope that this EDUCBA information on “PostgreSQL INSERT INTO” was beneficial to you. From this article, we saw how we can handle insert into statements correctly. # is used to show the number of rows inserted.įrom the above article, we saw the basic syntax of the insert into statement then we also saw how we can use insert into a statement by using different methods like single row and multiple rows with examples.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |