Re: [GENERAL] PostgreSQL For Beginners

2011-02-19 Thread Jasen Betts
On 2011-02-03, Kenneth Buckler wrote: > One of the programmers I work with is interested in migrating from > Oracle to PostgreSQL as the backend for his applications. > > Is there a PostgreSQL "beginners" guide available somewhere, which > might help him understand setting up a test database on h

Re: [GENERAL] PostgreSQL For Beginners

2011-02-03 Thread rick chu
I think an intro presentation for Oracle developers should include: -- sqlplus to psql comparison -- how to setup OS authenticated users in PostgreSQL -- purpose of pg_hba.conf -- schemas and search_path. -- where to find things in the catalog. information_schema or pg_tables Rick

Re: [GENERAL] PostgreSQL For Beginners

2011-02-03 Thread Andy Colson
On 2/3/2011 9:31 AM, Kenneth Buckler wrote: I'm probably going to be presenting to a mixed audience, some of the developers will have extensive Oracle knowledge, some will have MS SQL Server experience. Plus, I'm not extremely familiar with Oracle, so trying to compare the two would not work wel

Re: [GENERAL] PostgreSQL For Beginners

2011-02-03 Thread Andy Colson
On 2/3/2011 8:40 AM, Kenneth Buckler wrote: One of the programmers I work with is interested in migrating from Oracle to PostgreSQL as the backend for his applications. Is there a PostgreSQL "beginners" guide available somewhere, which might help him understand setting up a test database on his

[GENERAL] PostgreSQL For Beginners

2011-02-03 Thread Kenneth Buckler
One of the programmers I work with is interested in migrating from Oracle to PostgreSQL as the backend for his applications. Is there a PostgreSQL "beginners" guide available somewhere, which might help him understand setting up a test database on his Windows system? I may also be performing a 30