select * from pg_users;
>From: ÀîÁ¢Ð <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Tom Lane <[EMAIL PROTECTED]>, Dustin Sallings <[EMAIL PROTECTED]>
>CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Subject: Re: Re: [GENERAL] index on a
Tom Lane£¬
Does anyone who knows a user's information is storeed in what pgSQL's system table?
Thank all!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Dustin Sallings <[EMAIL PROTECTED]> writes:
> I was wondering, however, if there's a way I can use an index to
> avoid table scanning for this.
If you say "SET enable_seqscan TO off", and repeat the EXPLAIN, do you
get an indexscan plan?
I don't recommend doing such a SET for production pu
