Retrieve a list of databases using PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Try
SELECT datname FROM pg_database

eg:

<?
$db="template1";
$db_connect=pg_connect("host=192.168.101.1 user=postgres port=5432 dbname=$db");
$db_query="SELECT datname FROM pg_database";
$db_result=pg_exec($db_connect, $db_query);
$db_numrows=pg_numrows($db_result);

//display results

for ($i=0; $i<$db_numrows; $i++)
    {
        $pg_data=pg_fetch_row($db_result, $i);
            printf("$pg_data[0]\n");
                }
                ?>






[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux