How do I connect to PostgreSQL

Connecting to PostgreSQL can be achieved using various programming languages and libraries. Below is an example using PHP with the PDO extension to establish a connection to a PostgreSQL database.

<?php $host = '127.0.0.1'; // PostgreSQL server host $port = '5432'; // PostgreSQL server port $dbname = 'your_database'; // Database name $user = 'your_username'; // Database username $password = 'your_password'; // Database password try { $dsn = "pgsql:host=$host;port=$port;dbname=$dbname;"; $pdo = new PDO($dsn, $user, $password); // Set the PDO error mode to exception $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully to PostgreSQL database."; } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?>

keywords: connect to PostgreSQL PHP PostgreSQL connection PDO PostgreSQL example

Related Questions

How do I avoid rehashing overhead with std::set in multithreaded code?

How do I find elements with custom comparators with std::set for embedded targets?

How do I erase elements while iterating with std::set for embedded targets?

How do I provide stable iteration order with std::unordered_map for large datasets?

How do I reserve capacity ahead of time with std::unordered_map for large datasets?

How do I erase elements while iterating with std::unordered_map in multithreaded code?

How do I provide stable iteration order with std::map for embedded targets?

How do I provide stable iteration order with std::map in multithreaded code?

How do I avoid rehashing overhead with std::map in performance-sensitive code?

How do I merge two containers efficiently with std::map for embedded targets?