Re: [ADMIN] query for view code

2005-10-18 Thread Rajesh Kumar Mallah
Yes connect using psql -E database> \d viewname observe the query that are used to produce the view defination Regds Rajesh Kumar mallah. On 10/13/05, Colton A Smith <[EMAIL PROTECTED]> wrote: > Hi: > >Can I query the database for the code for a particular view? > > Thanks for your help!

Re: [ADMIN] scripts and ~/.psqlrc

2005-10-18 Thread Tomeh, Husam
" PGPASSWORD sets the password used if the server demands password authentication. Use of this environment variable is not recommended for security reasons (some operating systems allow non-root users to see process environment variables via ps); instead consider using the ~/.pgpass file " --

Re: [ADMIN] PostgreSQL running in the background....

2005-10-18 Thread Kevin Grittner
Hello Faeiz, When setting up our SuSE server, I found this page, and figured that I should probably comply with the recommendations I found there, even though we were setting things up "by hand" rather than through an RPM: http://www.novell.com/coolsolutions/feature/11256.html We started with th

Re: [ADMIN] Solving OID wrap-around in 7.4 DB?

2005-10-18 Thread Andrew Sullivan
On Sun, Oct 16, 2005 at 07:28:00AM -0400, Jeff Boes wrote: > On behalf of a previous employer who, due to major downsizing, is left > without an answer to this: > > What's the best way to treat impending OID wrap-around in a 7.4.8 > database? This DB has been online for about 18 months, and is exp

Re: [ADMIN] postmaster blues after system restart

2005-10-18 Thread Tom Lane
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > Does postgres just use /tmp because it will generally be known to > exist and be writable? I suppose that was the original motivation. We've had repeated troubles over the years with using /tmp --- for example, the code now goes to considerabl