From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: perl DBI::Pg metacharacter \i com_list.sql |
Date: | 2005-09-30 00:34:45 |
Message-ID: | 2bea75abda04d6b6d7fba4e01c4ad658@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> $com = $conn->prepare("\i comm_list.sql");
> $com->execute() or die $com->errstr;
>
> Anyone know what the syntax should be?
\i is a feature specific to psql, and is not used by DBD::Pg
(or anything else, for that matter). If what you are doing is
trying to run a collection of commands that are saved in a file,
you should use do() and normal perl file reading:
open(F, "$file") or die qq{Could not open the file "$file": $!\n};
while(<F>) {
$dbh->do($_);
}
This assumes each line is a valid, self-contained SQL command, of course.
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200509292033
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFDPIgKvJuQZxSWSsgRAqamAKDLO/aCQ6fH9bAAVYsRnVhb6P6QQQCg3YII
8773ggJIZYIQHaZXrWQm8N8=
=ekRH
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Lee Tucker | 2005-09-30 10:25:05 | How to get tabloid |
Previous Message | Ennio-Sr | 2005-09-30 00:05:59 | Re: postgres arithmetic: raising to nth power |