Shell Programming and Scripting

Hello All,

I am creating a Postgresql table like this

Code:

Create TABLE test (
       val1 varchar(80),
       val2 int );

In a perl script using DBI, I am trying to insert values into the above table using the below with no success. Can anyone see why?

Code:

$host=`hostname`;
chomp($host);
$tim=`date +%s`;
chomp($tim);
$val = "$tim"."$host";

$qry = "INSERT INTO test (val1, val2) values (\"$val\",10)";
$sth = $dbh->prepare("$qry");
$sth->execute();
$sth->finish();

The insert seems to be working only if the values I am trying to insert are numeric. Otherwise they are failing with "DBD::Pg::st execute failed:ERROR: column "abcd12345" does not exist at /tmp/test.pl line 22"