[SQL] (no subject)

2008-04-09 Thread Colin Martin
-- Colin Martin -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] (no subject)

2006-07-08 Thread onin
-- "A whim, a thought, and more is sought... awake, my mind... thy will be wrought!" ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

pg_dump inside function (was: Re: [SQL] (No Subject))

2004-06-11 Thread Martin Knipper
Please provide a subject for futher mailings to this list. Am 11.06.2004 06:36 schrieb William Anthony Lim: > is it possible to dump within procedural language/SQL syntax? > Using pg_dump from console is very confusing for some end user > who don't have Linux skills. so I decide to create a functi

Re: [SQL] (No Subject)

2004-06-11 Thread Franco Bruno Borghesi
I remember reading somewhere that it was possible to execute system commands from plperl...  don't know if it's the best way, but you could do an exec of pg_dump from inside a plperl procedure. On Fri, 2004-06-11 at 01:36, William Anthony Lim wrote: is it possible to dump within procedural la

[SQL] (No Subject)

2004-06-10 Thread William Anthony Lim
is it possible to dump within procedural language/SQL syntax? Using pg_dump from console is very confusing for some end user who don't have Linux skills. so I decide to create a function to do that, and they may call it from my application. Thanks William Need a new email address that people

Re: [SQL] (no subject)

2003-08-14 Thread Tom Lane
"A. Van Hook" <[EMAIL PROTECTED]> writes: > Dump files are used to restore and test. This test method has been used > successfully on > all previous versions. However, in 7.3.3, when the dump utility hits a > carriage return imbeded with in a text field, the > dump utility immeadiately jumps to t

[SQL] (no subject)

2003-08-14 Thread A. Van Hook
We have been using 7.3.3 on several different applications and have discovered an anomaly. Backups are done nightly using "pg_dump --attribute-inserts -f att.dump.`dcode` spdb"; Dump files are used to restore and test. This test method has been used successfully on all previous versions. However

Re: [SQL] (no subject)

2003-06-12 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > On Thu, 12 Jun 2003, A. Van Hook wrote: >> When updating from 7.2.3 to 7.3.3 we have lost the ability to see the >> passwords in pg_shadow. Is there a way to decrypt the passwords? > But you still can do > ALTER USER foo UNENCRYPTED password 'bar'

Re: [SQL] (no subject)

2003-06-12 Thread Achilleus Mantzios
On Thu, 12 Jun 2003, A. Van Hook wrote: > When updating from 7.2.3 to 7.3.3 we have lost the ability to see the > passwords in pg_shadow. Is there a way to decrypt the passwords? The default case (with md5 method in pg_hba.conf) is encrypted passwds. But you still can do ALTER USER foo UNENCRY

[SQL] (no subject)

2003-06-12 Thread A. Van Hook
When updating from 7.2.3 to 7.3.3 we have lost the ability to see the passwords in pg_shadow. Is there a way to decrypt the passwords? thanks -- A. R. Van Hook Honeywell Federal Manufacturing & Technologies IT System Engineer City of Lake Lotawana MO Mayor ---

[SQL] (No Subject)

2001-01-19 Thread Tony Mantana
Hello, I have visited your web site and found very interesting and informative. I would like to know: What is a BLOB Field and can you give a example of one? I hope to hear from you soon Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html