Hi,
You should escape the $. For eg, this prints $ literally:
perl -e 'print "\$";'
so you could do "create table foo\$bar (id integer);"
This has got nothing to with dbi.
- Sandeep
On Thu, 2005-09-29 at 16:37 +0200, moma wrote:
> Hi,
>
> i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4 and DBI version
> 1.46 with DBD::Pg version 1.32.
> i can create tables from psql with an $ in the middle of it, e.g. "create
> table foo$bar (id integer);"
> But if i try to do this
> $dbh->do("create table foo\$bar (id integer);");
> in a script, then following error is emiited:
> DBD::Pg::db do failed: Execute called with an unbound placeholder
>
> So i want to know, is it a bug or intended for portability?
>
> thanks
