Is there a way to create a ssh tunnel on a local server and the client application connect to it and the data is send to the remote server

Is there a way to create a ssh tunnel on a local server and the client
application connect to it and the data is send to the remote server

I make a ssh tunnel(home server) to connect to a database server with
PostgreSQL(remote server), so far everything is fine when i use psql -h
localhost -p 5433 -U user dbname, but the problem is i want my client
application connect to the (home server) on the forward port that i use in
ssh tunnel a then the port will be redirect to the port on the (remote
server), but so far is not working.
Can anyone help me to accomplish this.