logo
GCP-Practice-Tests
Trending

How to insert row in PostgreSQL

gcptutorials.com PostgreSQL
INSERT command inserts new rows into a table. for this tutorial we already have db created with with name "test_db". "test_db" is having table with name testtable. testtable contains two columns "id" and "name".
if you don't have dbs created than follow the link How to create database and tables in PostgreSQL.to create dbs and tables.

  • Switch to postgres shell with below two commands

    • [gcptutorial@localhost ~]$ sudo su - postgres -bash-4.2$ psql

  • Switch to database "test_db"

    • postgres=# \c test_db

  • Execute insert command

    • test_db=# INSERT INTO testtable (id, name) VALUES (6, 'user6');

    Categories: PostgreSQL

    Tags
    list_physical_devices functional model Crossentropy flatten() rust read file rust cargo compile rust install rust nodejs installation Jenkins installation Docker installation cuda-version Boston-Dataset tf.keras.utils String Operators test command Docker-Installation batch_flatten BinaryCrossEntropy

    Copyright © All rights reserved | This template is made with by Colorlib