In the past, I just create a new database to every apps I made. Recently, I try to connect to a PostgreSQL using a different schema in one database. Using ADODb, it’s relatively easy to connect:
try {
$DB->Connect("host=localhost port=5432 dbname=my_db user=my_user password=my_secret options=--search_path=my_schema);
} catch (exception $e) {
//var_dump($e);
echo 'Cannot connect';
}
Leave a Reply