From: | Philip Hallstrom <philip(at)adhesivemedia(dot)com> |
---|---|
To: | "Roderick A(dot) Anderson" <raanders(at)acm(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: MySQL password function |
Date: | 2002-07-10 21:06:57 |
Message-ID: | 20020710140539.R92143-100000@cypress.adhesivemedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm not sure what mysql uses for passwords, but the source is available so
you could always wrip out the code for their password function and make a
postgresql version... then you wouldn't have to change any of the SQL
scripts at all...
-philip
On Wed, 10 Jul 2002, Roderick A. Anderson wrote:
> Oh my god. I never thought I'd be asking a MySQL question on this list
> but being lazy this week I'll give it a shot.
>
> I'm attempting to convert an application from MySQL to PostgreSQL. Got
> pretty much all done except for a few lines loading some sample data into
> the tables. I didn't even notice this until I got an error message. Just
> cut and pasted the code into psql.
>
> The insert statement has one value of "password('foo')." Since the app
> was designed for MySQL I'm sure I'll run into this later so I need to
> figure out the PgSQL way or a workaround. My guess is this is a function
> to encrypt 'foo'. Is there a similar functionality in Pg? My look
> through Bruce's and the O'Reilly Mammoth books turned up nothing. Is
> there something in contrib that does this?
>
>
> TIA,
> Rod
> --
> "Open Source Software - Sometimes you get more than you paid for..."
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick L. Nolan | 2002-07-10 21:10:19 | C program Killed |
Previous Message | Matt Price | 2002-07-10 20:59:00 | web archiving |