Thread: Demo Database
We are going to be using a product that uses PostgreSQL as its underlying db. I am trying to get familiar with the Postgresql before the vendor comes to do the install, etc. I have downloaded and installed it on a small server and would like to learn more about the admin aspect of things -- I am a Microsoft SQL DBA - Sorry!
Where can I find a demo/sample Postgresql database that I can attach so I can become familiar with the Admin tool?
At this point I would like to 'sort of' compare the tool to what I see in Enterprise Manager - Where to find ....
Thanx!
Terry Cuddington
Database Administrator
Regina Qu'appelle Health Region
2110 Hamilton Street - 4th Floor
Regina, SK S4P 2E3
(306) 766-6844
FAX: 766-6801
Cuddington, Terry RQHR wrote: > We are going to be using a product that uses PostgreSQL as its > underlying db. I am trying to get familiar with the Postgresql before > the vendor comes to do the install, etc. I have downloaded and > installed it on a small server and would like to learn more about the > admin aspect of things -- I am a Microsoft SQL DBA - Sorry! No need to apologize, you converted at last :-) > > Where can I find a demo/sample Postgresql database that I can attach so > I can become familiar with the Admin tool? No demo db as northwind currently. Just launch pgAdmin and use the context menu. > At this point I would like to 'sort of' compare the tool to what I see > in Enterprise Manager - Where to find .... pgAdmin is the better combination of of enterprise manager and isqlw :-) Regards, Andreas
One thing I found handy early on as a sort of demo was to set up an ODBC connection to PostgreSQL and copy over some existingtables. (I copied from MS Access) Alan Andreas Pflug wrote: > Cuddington, Terry RQHR wrote: > >> We are going to be using a product that uses PostgreSQL as its >> underlying db. I am trying to get familiar with the Postgresql before >> the vendor comes to do the install, etc. I have downloaded and >> installed it on a small server and would like to learn more about the >> admin aspect of things -- I am a Microsoft SQL DBA - Sorry! > > > No need to apologize, you converted at last :-) > >> >> Where can I find a demo/sample Postgresql database that I can attach >> so I can become familiar with the Admin tool? > > > No demo db as northwind currently. Just launch pgAdmin and use the > context menu. > >> At this point I would like to 'sort of' compare the tool to what I see >> in Enterprise Manager - Where to find .... > > > pgAdmin is the better combination of of enterprise manager and isqlw :-) > > Regards, > Andreas > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > >