[SQL] Count of rows

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

Re: [SQL] Authentification failed

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

Re: [SQL] Foreign Key inter databases

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

[SQL] Foreign Key inter databases

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

[SQL] GiST index implementation

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