RE: Create tables using Perl DBI

Hum... I tried adding that extra ) at end of the prepare:

$sth = $dbh->prepare("create table customer (ID serial PRIMARY KEY, name
text NOT NULL, email text NOT NULL, phone text NOT NULL, fax text DEFAULT,
address text NOT NULL, address2 text DEFAULT, zip text NOT NULL, city text
NOT NULL, state text NOT NULL, country text NOT NULL)")   or die "Could not Create Table:
$DBI::errstr";$sth->execute;#disconnectfrom the database.$dbh->disconnect();
 

>
> It looks like you're missing a ")" in there somewhere.
> Parse error usually = syntax error.
>

Still the same error:

DBD::Pg::st execute failed: ERROR:  parser: parse error at or near ","

David Coley
davidcoley@home.com
http://www.davidcoley.com