<?php

// create_table.php

// Creates a table based on variables fieldname1, type1 and fieldname2, type2

$fieldname1	= $_POST['fieldname1'];
$type1			= $_POST['type1'];	
$fieldname2	= $_POST['fieldname2'];
$type2			= $_POST['type2'];

$PGCON = pg_connect(dbname="mydb" user="me" password="mypassword");

$query_string = "DROP TABLE demo";

pg_query($PGCON,$query_string);

$query_string = <<<EOT

	CREATE TABLE demo (
		$fieldname1	$type1,
		$fieldname2	$type2
	)

EOT;

pg_query($PGCON,$query_string);

pg_close($PGCON);

?>
