Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Class::DBI::Loader and Postgres schemas

by ides (Deacon)
on Oct 05, 2005 at 15:39 UTC ( #497641=note: print w/ replies, xml ) Need Help??


in reply to Class::DBI::Loader and Postgres schemas

Not currently, but it appears you can hack it to work. In Class::DBI::Loader::Pg.pm there is a line:

return $dbh->tables( undef, "public", "", "table", { noprefix => 1, pg_noprefix => 1 } );
Replace the "public" with the name of your schema and it should work as you want.

UPDATE: I've sent a patch off to the maintainer for this so hopefully it will be in the next release for you.

Frank Wiles <frank@wiles.org>
http://www.wiles.org


Comment on Re: Class::DBI::Loader and Postgres schemas
Download Code
Re^2: Class::DBI::Loader and Postgres schemas
by srdst13 (Pilgrim) on Oct 05, 2005 at 16:26 UTC
    Always good to hack. Thanks for sending off the patch. I guess it should also be possible to override db_main using another base class (?), but I haven't tried that yet.

    Sean
Re^2: Class::DBI::Loader and Postgres schemas
by ioannis (Vicar) on Jun 15, 2006 at 08:29 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://497641]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (6)
As of 2015-07-05 23:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (68 votes), past polls