dbix::class::storage::dbi::pg(3pm) [debian man page]
DBIx::Class::Storage::DBI::Pg(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Pg(3pm)NAME
DBIx::Class::Storage::DBI::Pg - Automatic primary key class for PostgreSQL
SYNOPSIS
# In your result (table) classes
use base 'DBIx::Class::Core';
__PACKAGE__->set_primary_key('id');
DESCRIPTION
This class implements autoincrements for PostgreSQL.
POSTGRESQL SCHEMA SUPPORT
This driver supports multiple PostgreSQL schemas, with one caveat: for performance reasons, data about the search path, sequence names, and
so forth is queried as needed and CACHED for subsequent uses.
For this reason, once your schema is instantiated, you should not change the PostgreSQL schema search path for that schema's database
connection. If you do, Bad Things may happen.
You should do any necessary manipulation of the search path BEFORE instantiating your schema object, or as part of the on_connect_do option
to connect(), for example:
my $schema = My::Schema->connect
( $dsn,$user,$pass,
{ on_connect_do =>
[ 'SET search_path TO myschema, foo, public' ],
},
);
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-11-29 DBIx::Class::Storage::DBI::Pg(3pm)
Check Out this Related Man Page
DBIx::Class::Storage::DBI::mysql(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::mysql(3pm)NAME
DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing MySQL specifics
SYNOPSIS
Storage::DBI autodetects the underlying MySQL database, and re-blesses the $storage object into this class.
my $schema = MyDb::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );
DESCRIPTION
This class implements MySQL specific bits of DBIx::Class::Storage::DBI, like AutoIncrement column support and savepoints. Also it augments
the SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type, which you can use by specifying "join_type => 'straight'" in the
relationship attributes
It also provides a one-stop on-connect macro "set_strict_mode" which sets session variables such that MySQL behaves more predictably as far
as the SQL standard is concerned.
STORAGE OPTIONS
set_strict_mode
Enables session-wide strict options upon connecting. Equivalent to:
->connect ( ... , {
on_connect_do => [
q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
q|SET SQL_AUTO_IS_NULL = 0|,
]
});
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::mysql(3pm)
Hi,
I have been trying to connect to sqlplus the same way I used to do in my earlier company but I get these error messages , please suggest way out -
user name - xyzuser
schema name - xyzschema
$ sqlplus xyzuser@xyzschema
ksh: sqlplus: not found.
$ sqlplus -s xyzuser@xyzschema... (5 Replies)
Hi All
I am able to connect my oracle database with Perl and able to execute the queries.
There is one schema names master19 which contains 50 table.
I want to take backup of each table in and store at a given directory location in Perl
For example suppose if a table student is present in... (1 Reply)
Hi All
I am able to connect my oracle database with Perl and able to execute the queries.
There is one schema names master19 which contains 50 table.
I want to take backup of each table in and store at a given directory location in Perl
For example suppose if a table student is present in... (3 Replies)
Hello,
Just a quick question
Usually from a PSERIES if you want to connect to IBM SAN Storage
you connect the IBM SAN Storage through a SAN Switch
something like this
---
however my question
Can you connect
from Pseries directly to San Storage without SAN Switch
what would be... (8 Replies)
Hello friends,
There is one requirment where I need to login into database environment and pull all schema names into a text file ...
as of now below are the schemas available...
$> describe keyspaces;
system_schema system_auth system abc system_distributed system_traces
Now from... (4 Replies)