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

    • [[email protected] ~]$ 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
    terraform-install total_ordering stack getattr lambda requests az network vnet az network nsg rule list az network nsg list az vm list-ip-addresses az vm create KDS list_physical_devices functional model Crossentropy flatten() rust read file rust cargo compile rust install rust

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