Re: psqlODBC and Access

On 23.04.2005 03:23, Typing80wpm(at)aol(dot)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.