[GENERAL] Design question

2005-07-29 Thread William Harazim
Title: Design question My company is looking to use PostgreSQL in place of our existing system. We currently house data for multiple clients. All of their data is stored in a single database in different schemas for each client. Mosts clients have multiple login accounts, which we maintain i

Re: [GENERAL] Manually authenticating users in pg_shadow

2004-01-27 Thread William Harazim
7;), 'hex' ) Thanks! -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 7:55 PM To: William Harazim Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Manually authenticating users in pg_shadow "William Harazim" <[EMAIL PROTECTED]> w

[GENERAL] Manually authenticating users in pg_shadow

2004-01-27 Thread William Harazim
redundant' user table and use pg_shadow. The authentication function I'm using is included in the attachment... Thanks. <> William Harazim, Software Engineer, Fulco Inc. 973-627-2427, x129 CREATE FUNCTION auth_user(text, text) RETURNS bool AS ' DECLARE salt text; BEGIN