RE: Re: extremely newbie questions

> -----Original Message-----
> From: Nicholas Chan [mailto:yumin(at)pl(dot)jaring(dot)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.