I want to use namespaces within my PostgreSQL database (schema in PostgreSQL world). However, they are not currently supported within the Catalyst scripts which will automatically build catalyst::schema automatically.
So the solution is to call Schema::Loader 'manually' with this incantation:
perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at("AddressBook::Addresses", { debug => 1, db_schema => "addressStuff" }, [ "dbi:Pg:host=localhost;dbname=testdb", "testuser", "123" ])'
so there you have it: thanks to the irc crew for sorting this out... and they pointed out that cross schema querying will require some jiggery pokery when I get to that...
PostgreSQL Extensions - A Deeper Look
-
My slides from my session "PostgreSQL Extensions - A Deeper Look" at
PostgresOpen 2019 and PostgresConf SV 2019
* PostgreSQL Extensions: A deeper look ...
4 years ago
No comments:
Post a Comment