CloudDB PostgreSQL

1. Connecting to the database

Install postgresql client:

sudo apt-get install postgresql-14

Check installed version:

psql --version

Connect to the database:

psql "postgres://username:password@hostname:port/defaultdb?sslmode=require"

List tables

\dt

Create table

CREATE TABLE tabela (first TEXT, last TEXT);

List table content

SELECT * FROM tabela;

Delete table

DROP TABLE tabela;