Re: Foxpro - Mailing list pgsql-general

At the most basic level, PostgreSQL is a client - server product, FoxPro is not.  It is MS Access' daddy and is very
similarin many ways (although vastly more capable in most ways.) 

They are apples and oranges.  You will probably not find any comparisons.

- Ian

>>> "David Siebert" <david@eclipsecat.com> 05/03/02 09:33AM >>>
I have a wannabe programer that works for me and he my not for long, nagging
me that we should use FoxPro instead of PostgreSQL and Java.
I have tried and tried to explain this to him. I have tried to show him that
FoxPro is not mainstream anymore. He is a pain in my butt. Would anyone like
to point me to a comparison between FoxPro and PostgreSql. I can find
comparisons between DB-2 or Oracle or MySQL and Postgres but not FoxPro. I
can guess why. I hate being a dictator about things like and I have tried to
help him by saying he could do one little internal project in FoxPro but he
can not even get FoxPro to use ODBC to connect to Postgres. I do not care to
learn anymore about ODBC than what I need to hook Openoffice calc to my
database.

By the way this guy does not even know how to do a binary or to decode a BCD
date. When I asked if it FoxPro had a binary shift he told me it had lots of
keyboard funtions :(


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Sean Chittenden
Sent: Monday, March 04, 2002 11:17 PM
To: Chris Bowlby
Cc: pgsql-general@postgresql.org
Subject: Re: [ADMIN] [GENERAL] password change...


> Hmmm hi all,
>
>  Alright I've GOT to be blind (knowing me it's a good possibility)... but
> I have a need to allow postgresql users to be able to change their own
> password, but if they don't have access to the pg_shadow or update user
> command how to I grant them this privilage and/or what command would
> they run....?

$ psql -q template1
template1=# \h ALTER USER
Command:     ALTER USER
Description: change a database user account
Syntax:
ALTER USER username [ [ WITH ] option [ ... ] ]

where option can be:

          [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
        | CREATEDB | NOCREATEDB
        | CREATEUSER | NOCREATEUSER
        | VALID UNTIL 'abstime'


--
Sean Chittenden

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)