Re: [GENERAL] Dump functions alone

2012-02-15 Thread Rajan, Pavithra
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_

Re: [GENERAL] Dump functions alone

2012-02-15 Thread Rajan, Pavithra
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

[GENERAL] Dump functions alone

2012-02-15 Thread Rajan, Pavithra
Hello all- Is there a way to just dump functions in a schema in to a txt file/ sql file ? Thank you.

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

2010-03-26 Thread Rajan, Pavithra
___ From: Timo Klecker [mailto:klec...@decoit.de] Sent: Friday, March 26, 2010 10:51 AM To: Rajan, Pavithra ; pgsql-general@postgresql.org Subject: AW: [GENERAL] Need help on updating an entire column with a list of values, I have. Hello, you could use an plpgsql function: CREATE OR REPLA

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

2010-03-26 Thread Rajan, Pavithra
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

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

2010-03-26 Thread Rajan, Pavithra
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

[GENERAL] Need help on updating an entire column with a list of values, I have.

2010-03-26 Thread Rajan, Pavithra
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)

Re: [GENERAL] How to get a list of tables that have a particular column value?

2009-12-24 Thread Rajan, Pavithra
..@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

[GENERAL] How to get a list of tables that have a particular column value?

2009-12-23 Thread Rajan, Pavithra
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