Trending

• 
  How to add tensors in TensorFlow

• 
  TensorFlow | How to use tf.GradientTape()

• 
  TensorFlow | How to use tf.reduce_sum in TensorFlow

• 
  GCP | how to use gcloud config set command

• 
  GCP | How to create kubernetes cluster with gcloud command

• 
  GCP | How to deploy nginx on Kubernetes cluster

• 
  How to install Terraform in Windows

• 
  GCP | How to set up and use Terraform for GCP

• 
  Python | check log file size with Subprocess module

Other Articles

• How to create Cloud Functions in GCP

• How to create Cloud Functions in GCP from Cloud Storage Buckets

• How to enable HTTP traffic for VMs in GCP with Firewall rules

• How to create scatter plot with Bokeh

• How to create charts in bokeh with flask

• How to install MongoDB in GCE Ubuntu VM

• How to use find command in Linux

• How to take database dump and restore in PostgreSQL

• How to use awk command in Linux

• How to insert row in 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');

Latest Articles

• 
  Python for beginners : Re Module

• 
  How to apply s3 bucket policy using Python

• 
  How to apply tags on EC2 instances using Python

• 
  How to setup boto3 credentials

• 
  How to attach IAM role to EC2 instance

• 
  How to enable versioning on S3 bucket

• 
  How to extract text from PDF files in Python

• 
  How to convert PDF file to image using Python

• 
  How to upload files to S3 Bucket using AWS CLI

• 
  TensorFlow tf.keras.activations.serialize

• 
  TensorFlow tf.keras.activations.deserialize

• 
  Python 3.10 installation on Amazon Linux 2

• 
  How to set up S3 cross region replication using AWS CLI

• 
  How to create S3 lifecycle rule using AWS CLI

• 
  How to use Data Source in Terraform