Database

Creating a database
image
Dropping Database
image
Commands
create database testdb;
​
drop database if exists testdb;
Connect to DB
-- using psql
\c test
See list of tables
-- using psql
\d                       #to see tables
\d <name of table>       #to see details about table

User Defined Data Types

Schema

Last modified 7mo ago