[GENERAL] Validating User

2005-12-28 Thread ShepherdHill DB Subscriptions
Hi, Please as a superuser how would I obtain an equivalent of this query: SELECT * FROM pg_shadow WHERE usename='userid' AND md5(passwd)='passwd' I browse the content of the pg_shadow and the passwd field shows something like md5... All I am after is to validate a user against pg_shadow table i

[GENERAL] Replicator

2005-09-18 Thread ShepherdHill DB Subscriptions
Hi, Does anyone know of any open source PostgreSQL replicator that can replicate data from Fedora Core4 to Windows Server? Can Slony do that? Thanks for your advice. Best regards. Chris. ---(end of broadcast)--- TIP 1: if posting/reading through

[GENERAL] Query Cost

2005-09-18 Thread ShepherdHill DB Subscriptions
Hi, I have a table with this schema: CREATE TABLE billing.bill ( sno serial NOT NULL, billno int4, det date NOT NULL, . . . CONSTRAINT bill_pkey PRIMARY KEY (sno) ) I want to execute a query that will not return any record. Which of these queries is cheaper please? 1. Select * from