Re: psqlODBC and Access

On 23.04.2005 03:23, Typing80wpm@aol.com wrote:
> Should I not use MONEY in defining  such fields to
> be used with ACCESS? Is there a different TYPE that I should use  in my
> definition?  Thanks!

 From http://www.postgresql.org/docs/8.0/interactive/datatype-money.html

"The money type is deprecated. Use numeric or decimal instead, in
combination with the to_char function."

> By the way, what would you suggest as a tool to administer the PostgreSQL
> databases. I mean, something sort of graphical which would display tables and
> names and relationships.

In case you don't like PgAdminIII you may try commercial products like

EMS PostgreSQL Manager
http://sqlmanager.net/products/postgresql/manager

What they call "Visual Database Designer" might just be what you are
looking for. It's an MS-Access-like, visual display of tables and
relations. But remember, it's a frontend and not a modelling tool.

For modelling better look at:

http://www.casestudio.com/

I don't think there's something better out there for the money, but it
takes some time to learn using it.