mysql to postgres

[SeenGee]

I've made a php file to access mysql and write to an xml file, i need to port this file to postgres. i'm very new to postgres and would appreciate any help people can provide in making this transition.

<?php
$link = mysql_connect ("localhost", "administrator", "password");
mysql_select_db("IAD", $link);
$_xml = ( bool ) false;
$result = mysql_query ("describe users", $link);

$count = 0;
while ($row = mysql_fetch_array($result)) {
   $fieldnames[$count] = $row[0];
   $count++;
}
$file= fopen("user.xml" , "w");

$_xml .="<?xml version=\"1.0\" encoding=\"iso-8859-1\" ?>\r\n";
$_xml .="<!-- table users -->";
$_xml .="<users>\r\n";
$result = mysql_query ("select * from users", $link);
while ($row = mysql_fetch_object($result)) {
   $count = 0;
   $_xml .="    <record>\r\n";
   foreach ($row as $data) {
      $_xml .="        <$fieldnames[$count]>$data</$fieldnames[$count]>\r\n";
      $count++;
   }
   $_xml .="    </record>\r\n";
}
$_xml .="</users>";

fwrite($file, $_xml);
fclose($file);
echo $_xml;
mysql_close ($link);
?>

Cheers for taking the time to look through my code.

[stolzyboy]

sxooter, there is a postgresql question for ya, since you are probably one of the only people on here that knows the in's and out's of postgresql

[Sxooter]

The only changes that should affect you will be that in Postgresql you select a database while connecting (part of the connect string) and you can't change them while connected (you make another connection.)

Next you want a list of the users, you can use "select * from pg_user" and the field you want is username.

To see a list of all the system tables (there's quite a few) type \dS from a psql prompt.