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!
" 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 "
--
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
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
"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