How to access psql from perl script?

jisha · #1 (**permalink**) 04-28-2008

Hi All,

How to access the postgreSQL from a perl script?
Thanks in advance
JS

hanu_oracle · #2 (**permalink**) 04-28-2008

Quote:

Originally Posted by jisha

Hi All,

How to access the postgreSQL from a perl script?
Thanks in advance
JS

The following method is used to connect plsql from the Bash:

sqlplus -l USERNAME/PASSWORD@DBNAME <<EOF
insert into TABLE_CFS_DUMP(FILE_NAME, REGION_ID, SDP_ID, SEQUENCE_ID, TOTAL_RECORDS) values ('$file','$region_id','$sdp_id','$sequence_id', '$sub_records');
EXIT
EOF

KevinADC · #3 (**permalink**) 04-28-2008

use the DBI module and the respective driver for the type of database. You will probably have to install the DBI module and the driver. You can find them on CPAN.

The CPAN Search Site - search.cpan.org

I can't help with code examples because my SQL knowledge is very limited.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Calling a perl script from a perl script	new2ss	Shell Programming and Scripting	6	05-24-2009 05:03 PM
Access Sharepoint via perl	tcomku	Shell Programming and Scripting	0	03-04-2008 11:12 PM
Perl Database access	mercuryshipzz	Shell Programming and Scripting	2	01-16-2008 01:54 AM
Perl: Run perl script in the current process	vino	Shell Programming and Scripting	10	12-09-2005 10:45 AM
Perl CGI to access / edit "root" owned config files	WIntellect	Shell Programming and Scripting	1	04-23-2003 03:48 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by