inst-resources/postgresqlutil.php
author Dan Fuhry <dan@enanocms.org>
Sat, 21 Aug 2010 18:20:18 -0400
changeset 11 b62383876fdb
parent 0 67e1cc6cd929
permissions -rw-r--r--
Merged from accidental split

<?php

// PostgreSQL utility script.

if ( $argc < 2 )
  die("Usage: {$argv[0]} username password");

$user = addslashes($argv[1]);
$pass = addslashes($argv[2]);
$handle = pg_connect("host=localhost port=5432 user='$user' password='$pass'");
if ( !$handle )
{
  echo "PostgreSQL authentication failed.";
  exit(1);
}

if ( !empty($argv[3]) )
{
  $queries = explode(';', $argv[3]);
  foreach ( $queries as $query )
  {
    $query = trim($query);
    if ( empty($query) )
      continue;
    echo "$query;\n";
    if ( !pg_query("$query;") )
      exit(1);
  }
}

exit(0);