Hi All,I am new to postgresql. I want to send email by using pl pgsql. I want
to know how to set up the configurations for mail server.Can any one help me
in solving this?. pavithra@gmail.com
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Need-psql-send-email
I am more wondered where we need to give the port address and smtpserver.
Can you give me the details of these?.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Need-psql-send-email-tp5724700p5724705.html
Sent from the PostgreSQL - general mailing list archive at Nabbl
I have pgAdmin-III.It has version 1.12.3.I would like to run a job. I have
schedule an SQL Job. But when i run there is no output.Can anybody let me
know what needs to be done?.Also, Can any one tell, where i need to look for
the errors, when i run a job?.
--
View this message in context:
http:
I have a scheduled a sql query as "select sysdate from dual" and i have given
as "Data Export".
Moreover i cant see the debugger option, or any error log where i can see
it,
Can you tell me any suggestions on this?.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Need
I dont get my psql console itself disabled in the plug-ins menu.Is there a
way i can see the error log?.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Need-to-run-a-job-in-PgAdmin-III-tp5725093p5725110.html
Sent from the PostgreSQL - general mailing list archive at Na
Hello - I would like to know if there is a way to find all the table
names in a data base that have a particular column value eg:"volt" .ie
given a column value (not column name) how to I find which tables and
their column names have them .Thank you.
Pavithra Rajan
<mailto:raj...@coned.com>
..@hogranch.com]
Sent: Wednesday, December 23, 2009 3:11 PM
To: Rajan, Pavithra
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get a list of tables that have a
particular column value?
Rajan, Pavithra wrote:
>
> Hello - I would like to know if there is a way to find all the t
Hello - I have this table with 90 rows, which contains 2 columns ,column
A (type 'numeric') and column B(type text) . Column 'A' is filled with a
constant number and column 'B' has an unique entry for each row.
E.g. A B
(numeric)(text)
Hello ,
Yes -I need to get the exact the same result as you had listed.Thanks.
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:12 AM
To: Rajan, Pavithra ; pgsql-general@postgresql.org
Subject: AW: [GENERAL] Need help on
Yes thanks -I am trying to figure writing out a script that will do the update
than doing individual inserts or update.I'll try this idea.
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:51 AM
To: Rajan, Pavithra ; pgsql-ge
eger was cutting out leading zeros in entries.
I := I + 1;
end loop;
end;
$BODY$
LANGUAGE 'plpgsql';
Select
update('{06959.0,15308.0,15968.0,18916.2,19961.0,26528.0,29553.0,29872.0,30631.0}')
Rgds
Pavithra
_
Hello all- Is there a way to just dump functions in a schema in to a
txt file/ sql file ? Thank you.
ump >yourfunctions.sql
mentioned in
http://archives.postgresql.org/pgsql-general/2005-10/msg01633.php
I'll try this and your solutions as well
From: Raghavendra [mailto:raghavendra@enterprisedb.com]
Sent: Wednesday, February 15, 2012 11:05 AM
To: Rajan, Pavithra
Cc: pg
R(v_OldDivision,1,3);
v_Message := 'Changed Incident Division to ' || coalesce(v_Value,'')
|| ' from ' || coalesce(v_OldValue,'');
update OM_Incidents
set
Division = v_Division
where
IncidentId = v_IncidentId;
PERFORM om_ins_
14 matches
Mail list logo
