moma wrote:
i believe this is the DBD::Pg driver interpreting the $ as a
placeholder. i think you can surpress placeholder parsing with the
pg_direct attribute eg
$dbh->do("create table foo\$bar (id integer)", { pg_direct => 1} );
although i think this is only available in the latest versions
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);");
oops! Muy Bad! I need more coffee :)
Sorry, I have no solution for this.
- Sandeep
On Thu, 2005-09-29 at 11:12 -0400, Ronald J Kimball wrote:
> Sandeep Chayapathi [mailto:[EMAIL PROTECTED] wrote:
> >
> > You should escape the $. For eg, this prints $ literally:
> > perl -e 'print "\$";'
> >
Sandeep Chayapathi [mailto:[EMAIL PROTECTED] wrote:
>
> You should escape the $. For eg, this prints $ literally:
> perl -e 'print "\$";'
>
> so you could do "create table foo\$bar (id integer);"
That *is* what he tried to do:
> > But if i try to do this
> > $dbh->do("create table foo\$bar (i
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.
moma wrote:
Hi,
Hello,
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);"
That seems like a bad bad bad bad idea because how can you
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,