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