[GENERAL] Connection string

[Harpreet Dhaliwal]

Hi,
I'm trying to connect to postgres database in  a distributed environment, say from machine X to Machine Y (Machine Y has postgres DB)
How should my connection string look like in a program in Machine X.

EXEC SQL CONNECT TO ------??? (Do i need to specify the IP of DB server?)
I tried a few options but nothing works.
Can someone please write this connection string for me?

Thanks in advance,
~Harpreet