Re: [SQL] [GENERAL] pgcrypto-crypt
On 4/6/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: > dear all, > i want to encrypt and decrypt one of the fields in my table (i.e-password > field) > i have searched and with the help of pgcrypto package, using function > "crypt", i am able to encrypt my data, > but there is nothing which i found to decrypt that same data, > plz anybody give me the function to decrypt that encrypted value. The crypt function can't be decrypted (whether it's in postgresql or anywhere else). Crypt is meant to be used for passwords and such that you don't need to reverse (you only compare against). -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [SQL] Truncate on pg_dump / pg_restore
On Sat, Oct 25, 2008 at 5:32 PM, Bryce Nesbitt <[EMAIL PROTECTED]> wrote: > Dear Postgres Gurus; > > Is there a way to truncate a table, at pg_dump time? > > I'm aware of various ways to exclude a table from a dump (>= 8.2), or to > selectively pg_restore. What I'm seeking here is different. I've got > tables with pretty disposable data... meaning I want to drop the data... > but restore empty indexed tables at pg_restore time. Do a schema-only dump. pg_dump --help says use '-s' or '--schema-only'. -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
