Ok, can you run the following query for me: select u.username, c.dbname from users u, users_conf c where c.id = u.id;
Best Wishes; Chris Travers On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: > (This message bounced due to size, so resending) > > First did: > > [EMAIL PROTECTED]:/home/mythtv$ psql -U postgres ledger-smb > Welcome to psql 8.1.8, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > ledger-smb=# \d > List of relations > Schema | Name | Type | Owner > --------+--------------------- > ---+----------+------------ > public | session | table | ledger-smb > public | session_session_id_seq | sequence | ledger-smb > public | users | table | ledger-smb > public | users_conf | table | ledger-smb > public | users_id_seq | sequence | ledger-smb > (5 rows) > > > Then did: > > [EMAIL PROTECTED]:/home/mythtv$ psql ledger-smb ledger-smb > Welcome to psql 8.1.8, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > ledger-smb=# \d > List of relations > Schema | Name | Type | Owner > --------+------------------------+----------+------------ > public | session | table | ledger-smb > public | session_session_id_seq | sequence | ledger-smb > public | users | table | ledger-smb > public | users_conf | table | ledger-smb > public | users_id_seq | sequence | ledger-smb > (5 rows) > > ledger-smb=# > > > Regards, > > On 3/15/07, Chris Travers <[EMAIL PROTECTED] > wrote: > > Ok, that is weird.... > > > > Try (in the same db): > > \d > > And send us the results. > > > > If you want to send it to a file, you can go: > > \o filename > > \d > > \q (to quit) > > > > Best wishes, > > Chris Travers > > > > On 3/15/07, Matt Jackson <[EMAIL PROTECTED] > wrote: > > > I must be cursed: > > > > > > [EMAIL PROTECTED]:/home/mythtv$ psql -U ledger-smb ledger-smb > > > Welcome to psql 8.1.8, the PostgreSQL interactive terminal. > > > > > > Type: \copyright for distribution terms > > > \h for help with SQL commands > > > \? for help with psql commands > > > \g or terminate with semicolon to execute query > > > \q to quit > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
