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