[GENERAL] check data for datatype

> > Hi All: > I have a very large table and the column type is text. I would like to convert in numeric. How can I find rows that dont have numbers. I would like to delete those rows. Thanks, -Suersh Raja

[GENERAL] function to send email with query results

Hi all: I'm looking to write a function to send email with result of a query.Is it possible to send email with in a function. Any help is appreciated. Thanks, -Suresh Raja

[GENERAL] documenting tables version control

on on table name, column names, column order, pry key column etc. Also is there a way I can reverse engineer from the database itself. Let me know if anybody any suggestion or format that they used. I appreciate all your help and shall be suitably acknowledged. Thanks, -Suresh Raja

Re: [GENERAL] documenting tables version control

ordinal_position; > > On Tue, May 5, 2015 at 4:28 PM, Joshua D. Drake > wrote: > >> >> On 05/05/2015 01:13 PM, Suresh Raja wrote: >> >>> Hi All: >>> >>> >>> I have tables with different versions in the same schema. Like &

[GENERAL] extracting PII data and transforming it across table.

n all files. I'm looking for a easy solution. Thanks, -Suresh Raja

Re: [GENERAL] [SQL] extracting PII data and transforming it across table.

ies. Plus it should be easier to build some test queries in SQL to > validate that your ID adjustments were valid. > > On Thu, May 21, 2015 at 9:27 AM, Suresh Raja > wrote: > >> Hi Folks: >> >> I'm looking at directions or help in extracting data from pro

Re: [GENERAL] extracting PII data and transforming it across table.

Hi All: Does postgresql support schema analyze. I could not find analyze schema anywhere. Can we create a function to run analyze and reindex on all objects in the schema. Any suggestions or ideas. Thanks, -Suresh Raja

[GENERAL] Run analyze on schema

> > Hi All: > > Does postgresql support schema analyze. I could not find analyze schema > anywhere. Can we create a function to run analyze and reindex on all > objects in the schema. Any suggestions or ideas. > > Thanks, > -Suresh Raja >

Re: [GENERAL] Run analyze on schema

On Mon, Jun 22, 2015 at 6:53 PM, Jerry Sievers wrote: > Suresh Raja writes: > > > Hi All: > > > > Does postgresql support schema analyze. I could not find > > analyze schema anywhere. Can we create a function to run > > analyze and reinde

[GENERAL] encrypt psql password in unix script

Hi: I cannot use .pgpass as the password stored here is not encrypted. can i use a encrypted password from unix shell script. has anybody ran into same situation. Wht options do i have. Thanks, -SR

[GENERAL] refer function name by a variable in the function body

Hi All: I use the function name in the body of pgsql code of the same function. Is the function name set to any variable that i can easily reference. Now I'm hard coding the function name in the code. create or replace function compute_X(a1 text) returns text as . ... Begin . selec

[GENERAL] localtime(0)

Hi: I'm using localtime(0) in various part of the function, and updating table with the time. I use localtime at places like the start of the function and at the end of the function. The function takes about 5 mins to run,. The issue is that the function always print the same time for both start

Re: [GENERAL] localtime(0)

clock_timestamp() gives more than I need. i just need time, - no date, or msec or timezone. How can i get to print the current time alone. Thanks, On Mon, Dec 29, 2014 at 10:41 AM, Adrian Klaver wrote: > On 12/29/2014 08:32 AM, Suresh Raja wrote: > >> Hi: >> >> I

[GENERAL] commit inside a function failing

Hi All: We are running a function with a loop in it. We tried commit; We are getting error with above command. How can i easily commit withing a function. Thanks, -SR

[GENERAL] check if the same function is already running, then exit!

Before running a running a function, i would check only 1 instance is running. If alreaady a function is running, the existing function should exist with the msg that already a function with same is running. If somebody has already used such a faeture, can u please share or Can you tell me the ta