[OPEN-ILS-GENERAL] pgAdmin usage?

[Tony Bandy]

Thanks for the good info...this really helps.  I can poke around with Vi
pretty good, but still learning postgres, etc.  Having this new tool will
help a bunch.  Now, back to working on my Mac client! :)

Appreciate it!

Tony



On Fri, Sep 21, 2012 at 1:11 PM, Sharp, Chris
<csharp at georgialibraries.org>wrote:

> > Of course, depending on your permissions, you can accidentally change
> > data in tables, so one should be careful when clicking around too.
>
> Which is why it's a great idea to create a read-only user for such
> connections.
>
> ----- Original Message -----
> > From: "Ben Shum" <bshum at biblio.org>
> > To: open-ils-general at list.georgialibraries.org
> > Sent: Friday, September 21, 2012 1:01:38 PM
> > Subject: Re: [OPEN-ILS-GENERAL] pgAdmin usage?
> >
> > Hi Tony,
> >
> > We've been using pgAdmin all along to work with our PostgreSQL
> > databases. Personally, I've liked having a graphical view of certain
> > tables. It also gave me a bird's eye of the various inner workings
> > of the tables too without knowing all the SQL syntax required.
> >
> > The most annoying thing that can go wrong with using pgAdmin in my
> > experience is opening a table to view all rows and not remembering
> > said table contains thousands (if not millions) or entries. Like
> > clicking view all on biblio.record_entry would show me every bib
> > record in my database. Doing so tends to crash out pgAdmin as it
> > tries in vain to open all the rows for me. I've taken care to using
> > "view 100" to only get a sampling of a table.
> >
> > Of course, depending on your permissions, you can accidentally change
> > data in tables, so one should be careful when clicking around too.
> >
> > -- Ben
> >
> >
> > On 9/21/2012 12:03 PM, Tony Bandy wrote:
> >
> >
> > Hi all,
> >
> >
> > Working on increasing my knowledge of Evergreen's inner workings,
> > I've come across some threads on using pgAdmin to do various db
> > tasks and queries. Just wanted to pitch this out there and get
> > anyone's thoughts on the pro vs. con of using this particular tool
> > vs. console usage.
> >
> >
> > Good tool or dangerous?
> >
> >
> > Thanks for your thoughts.....Happy Friday!
> >
> >
> > Tony
> >
> >
> > *******************************************
> > Tony Bandy
> > tonyb at ohionet.org
> > OHIONET
> > 1500 West Lane Ave.
> > Columbus, OH 43221-3975
> > 1-800-686-8975 x19
> > ********************************************
> >
> >
> >
> > --
> > Benjamin Shum
> > Open Source Software Coordinator
> > Bibliomation, Inc.
> > 32 Crest Road
> > Middlebury, CT 06762
> > 203-577-4070, ext. 113
>
> --
> Chris Sharp
> PINES Program Manager
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120921/a9a024be/attachment.htm>