RE: Re: extremely newbie questions

> -----Original Message-----
> From: Nicholas Chan [mailto:yumin@pl.jaring.my]
> Sent: 22 January 2001 17:40
> To: Postgresql Interfaces
> Subject: [INTERFACES] Re: extremely newbie questions
> 
> 
> 
> Again, thanks for your reply!
> 
> 
> > You can compile PostgreSQL to run on your PC if you are 
> running NT4 or W2K
> > (that's how I develop pgAdmin when I'm parked in front of 
> the telly at home
> > with my laptop!). You need to use the Cygwin package - there are
> > instructions in the PostgreSQL tarball.
> 
>   Are there any readily compiled windows NT versions to be
>   downloaded?

Probably. I don't know where though.

> > Yes, pgAdmin does that (converts Access tables/indexes but 
> *not* programs to
> > PostgreSQL). I think a little clarification is needed here: 
> pgAdmin is an
> > admin/design tool for the PostgreSQL database system. 
> PostgreSQL is *not*
> > just a file like a simple Access database, it is a program 
> that accepts and
> > processes SQL queries and returns resultsets when 
> appropriate. It has it's
> > own data files that pgAdmin knows nothing about.
> > 
> > Typically PostgreSQL will run on a server and accept 
> connections from 1 or
> > many (perhaps hundereds) of client programs (or people 
> running the same
> > program). pgAdmin is one such program that just happens to 
> be designed to
> > help manage and build your databases.
> 
>   Thanks for the clarification, Dave.
>   That explains a lot of things!
>   And are there any database converters out there which can
>   convert windows based databases, especially Microsoft Access,
>   to PostgreSQL database readable files other than pgAdmin?

I believe there was once some Access code that did it (though I don't know
where it is). I doubt that it migrated tables, indexes, data as well as
primary and foreign keys as the upcoming pgAdmin will! The current version
does tables indexes and data BTW.