Hi all,
what is the default implementation for GiST index? B-Tree or R-Tree?
That is, if i execute the following SQL command:
CREATE index ON table USING Gist (column)
what is the type of the index that is actually built?
If I specify R-Tree instead, with:
CREATE index ON table USING
Hi all!
Is it possible to have a foreign key where referenced table is in
another database?
Thank you in advance
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMA
On 8/2/07, Dani Castaños <[EMAIL PROTECTED]> wrote:
> Hi all!
>
> Is it possible to have a foreign key where referenced table is in
> another database?
>
> Thank you in advance
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, p
On 02-Aug-07, at 2:49 AM, Judith wrote:
I'm trying in SUSE to connect to a postgres db and this is the error:
Ident Authentification failed for user <>
I'm already created the user with createuser root, but the error
persist, I would aprecciate some help, thanks in advanced
edit your
What's the best way to count how many rows are in each table via SQL? Or
is it even possible?
I'm trying something like:
select tablename, count(*) from (select tablename from pg_tables where
schemaname = 'public') as test group by tablename;
But obviously this just gives a count of 1 for ea
