[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] 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

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] 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] 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

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

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

n all files. I'm looking for a easy solution. 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] 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

[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] 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] 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

[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

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] 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

[GENERAL] Profiling postgres

w do I run ./postgres test under the profiler ? thanks and regards, Suresh

Re: [GENERAL] Writing a user defined function

Hello, Version is 8.1.3. Its an older version, in which I have some custom code. I want to test the code with a function which has a seq scan and a blocking loop. Thanks, Suresh --- On Sun, 7/20/08, Pavel Stehule <[EMAIL PROTECTED]> wrote: From: Pavel Stehule <[EMAIL PROTECTED]>

[GENERAL] Meaning og Logs

of these statements. Regards, G. V. Suresh Gupta - Innovative Technology Solutions(ITS), Zensar Technologies Zensar Knowledge Park, Plot#5, MIDC IT Tower, Kha

[GENERAL] Can we have 2 databases on same server

e the options like switching the database, the 2 databases are compulsory, right?(Thinking only one server is available.) Can you pls advice on this. Regards, G. V. Suresh

[GENERAL] Password authentication failed

Hi! I am a complete newbee to Postgres. Have installed Postgres on Windows 2003 server SP1 a week back. When I try to log-in to the server (by writting psql mydb at command prompt in postgres/bin directory), I keep getting a message "psal: FATAL: password authentication failed for user"Administ

[GENERAL] understanding post gres indexes

hi, i want to fully understand the functioning of postgres indexes with respect to the code. where can i find help regarding this ? any detailed manuals available ?? -- IYENGAR SURESH P. MTECH 1 , IIT BOMBAY HOSTEL 8 , ---(end of broadcast

Re: [GENERAL] How to uninstall Postgres on Iinux.

> Go the installation directory and try #make uninstall - > if it doesn't work then do the following # make clean # make dist clean and remove the directory manually regards suresh ---(end of broadcast)--- TIP 3: Have you

Re: [GENERAL] How to uninstall Postgres

y way you have goto your source directory where you have started your installation and give the command # make clean # make dist clean and remove the directory. It should work in most of the cases. regards suresh ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] help me pls

hi this following words from Dinesh did worked for me. Thanks guys and really appreciate your help and advice. PG_DATA=/usr/local/pgsql/data regards suresh ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] help me pls

ot; is missing. though i have follwed the instructions, somewher i'm missing the concept....   help me please. regards suresh

[GENERAL] help me learn

hi, i'm new to postgreSQL as well as new to database concepts.  please tell me how can i learn. i mean the easiest and fast way.  Your help will be appreciated.

[GENERAL] Overloading || ( text,text ) operator

Hi, I was trying to overload concat operator ||(text,text) such a way that it behaves like Oracle. i.e. I want 'abc' || null to return 'abc' instead of null. I know that it is not the expected behaviour in postgres, but since I am migrating the database from oracle to postgres , I need this behav

Re: [GENERAL] Overloading '<' operator

I used the internal function text_pattern_lt and it is working fine! Thanks for helping. cheers Suresh ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match