Thread: Demo Database

Demo Database

From
"Cuddington, Terry RQHR"
Date:
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
 

Re: Demo Database

From
Andreas Pflug
Date:
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


Re: Demo Database

From
Alan Corey
Date:
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
> 
>