> 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" <bs...@biblio.org> > To: open-ils-general@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 > to...@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 csh...@georgialibraries.org http://pines.georgialibraries.org/
