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
terry.cuddington@rqhealth.ca <mailto:terry.cuddington@rqhealth.ca>

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

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 existing tables. (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
>
>


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster