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