how to change database in use postgres code example Example: change database postgres psql: \connect DBNAME. or in short: \c DBNAME.