[GENERAL] DB Design Tools

1998-09-14 Thread Michael Ansley
Hi, I'm reasonably new to PG SQL, and managed to get everything up and going without too many hassles (except for the -i switch - ha, bloody ha), but now I need to get down to some serious development. What is/are the tool(s) generally used for design work on PG, and where can I get hold of

[GENERAL] SELECT from other's tables

1998-09-14 Thread Sergei Chernev
Hello, Sorry if it's FAQ but, how to select from smb's tables. So, I have an access to tables: bob=> grant all on AA to ser; CHANGE ser=>select * from aa; ERROR: aa: Table does not exist. Thanx. --- Sergei Chernev Internet: [EMAIL PROTECTED] Phone: +7-3832-397354

[GENERAL] Readin money type into java BigDecimals

1998-09-14 Thread Lincoln Spiteri
Hello, I am having trouble creating java BidDecimal objects from data stored in postgres as money. The problem seems to be due to formating of money inpostgres (eg $12,000.00) which cannot be parsed by java. Is there anyway I can change the formating of the money type in postgres, or should I u