Psql commands

psql

# connect
psql -h <host> -p <port> -U <user>
psql -h dev.localhost -p 15534 -U postgres

# list databases
\list

# connect to database
\connect <databasename>
\connect senz

# select query
select * from employee where name='eranga'

# update query
update employee set name = ‘eranga’ where id=’12';

# list tables
\dt

# view table structure
\d+ <table name>
\d+ employee

# exeucte sql script
psql -Upostgres -d senz -h dev.localhost -f updateSenz.sql -p 15534

# base64 decode
decode('<encoded data>', 'base64')

#base64 encode
encode('<data>', 'base64')