How to access psql from perl script? Post: 302190043

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl Database access

Hi, I tried to run this code but it isnt giving me any output or errors. My aim is to retrieve the row based on the flag name(this is the primary key). flag_test is my table This is how i ran it: perl read_db.pl flag1 flag1 is the criteria in where clause -------- this is my...

2. Shell Programming and Scripting

Access Sharepoint via perl

Hi All, I like to know if there is any module/package in perl to connect to a sharepoint? Please help!!! Thanks, TC

3. UNIX and Linux Applications

strange behavior of PSQL user defined function

Segregated the problematic portion, and showing for your view here., 1. Following is the function definition, create or replace function new_del(id integer) returns void as $$ begin raise info 'dollar :%',$1; delete from testing where id=$1; end ; $$ language 'plpgsql'; ...

4. Shell Programming and Scripting

psql output without return \n

Hi Everyone, When i finish running # echo `psql -t -U root databaseA -c "select a, b from book"`; i get the output 107275 | 14 107301 | 2 107446 | 6 107820 | 77 107929 | 101 Would like to have the result like: 107275 | 14 107301 | 2 107446 | 6 107820 | 77 107929 | 101

5. Shell Programming and Scripting

How do i access sybase using isql and how do i get result set in perl script?

Hi, How do i get result set in perl script using isql while connecting sybase server. I have a perl script which connected to sybase and get the result set. but i wanted to get the result set. How do i get the result set in perl script not unix shell script.. $server ="ServerName"; open...

6. Shell Programming and Scripting

Need to access Oracle DB with shell/perl script in Unix

Hi, We need to access Oracle DB with shell/perl script in Unix. Is Oracle client needed in Unix for this. I have seen threads which tell abt using SQL plus to access Oracle tables. Can we access DB without SQL PLus installation using scripts in UNix like we access DB using jar files in Java ....

7. Shell Programming and Scripting

Perl Hash access

Suppose I have a hash: my %table1 = ( 'Sam' => { 'Company' => 'XYZ', 'Post' => 'Software Engineer', 'Skills' => 'Perl', ...

8. Programming

Psql replace blanks with character

Well as the title describes, its a pretty straight forward problem. I have a series of psql tables where there are lots of blanks. However there is at least one column, called name, that will never be blank. I want to write a select statement to get all of the contents of the table and then turn...

9. Shell Programming and Scripting

Psql output into array and read 2 fields into different variables

Hello Just edited the entry to make it easier to understand what i want How can i achieve this: GOAL: read 2 field from a table with PSQL result of this PSQL command is this INSTALLEDLANG=$(su - postgres -c "psql -A -t -q -c -d ${DBNAME} -t -c 'SELECT code, iso_code from res_lang'") ...

10. Shell Programming and Scripting

PSQL multiple queries output to file

Hi, I have a shell script containing multiple PSQL queries for which I want the output to be redirected to a text file. psql -U postgres -d database -o textfile.txt << EOF Query1; Query2; Query ....; EOF When executing the script, queries outputs are directed to textfile.txt, however...

LEARN ABOUT DEBIAN

build-lives-rfx-plugin

build-lives-rfx-plugin(1)				      General Commands Manual					 build-lives-rfx-plugin(1)

NAME

       build-lives-rfx-plugin - builds rendered effects for LiVES

SYNOPSIS

       build-lives-rfx-plugin script_name [plugin_dir] -get section file

DESCRIPTION

       This perl script is used by LiVES to compile an RFX (rendered effect) plugin for LiVES. It is generally called from build-lives-rfx-plugin-
       multi for a script which has a language code representing LiVES-perl. The script_name must be  the  full  (absolute)  path  to  the  plugin
       script,	and  plugin_dir  can  be  used to specify the output directory where the compiled plugin should be generated. If plugin_dir is not
       defined then /tmp is assumed.

       The second variant with -get is used to print out a script section from a plugin script to stdout. It is generally only used internally	by
       LiVES.

       Return values The script returns the following values

       0 - success 1 - the value of a trigger was greater than the number of parameters 2 - a value could not be read from the script file 3 - the
       language code of the plugin script was not equivalent to LiVES-perl 4 - the API version level of the plugin script  was	invalid  5  -  the
       <define> section was missing from the plugin script

SEE ALSO

       build-lives-rfx-plugin-multi(1), lives(1)

AUTHOR

       Gabriel Finch a.k.a Salsaman (salsaman@xs4all.nl)

								    May 9 2010						 build-lives-rfx-plugin(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl Database access

Discussion started by: mercuryshipzz

2. Shell Programming and Scripting

Access Sharepoint via perl

Discussion started by: tcomku

3. UNIX and Linux Applications

strange behavior of PSQL user defined function

Discussion started by: thegeek

4. Shell Programming and Scripting

psql output without return \n

Discussion started by: jimmy_y