[ADMIN] Accessing large objects

2009-03-21 Thread c k
Hello, how to access large objects from the database when using PGAdmin like client applications? When a normal select is executed on lo type columns it gives only the number which refers to large objects stored in 'pg_largeobjects' table. When records from pg_largeobjects are fetched using

Re: [ADMIN] vacuuming and reindexing

2009-03-21 Thread Diogenes Caraballo
do you also update rows of that table? because that action delete old one's and insert new one's.. if you are just inserting rows and not updating or deleting, i think is correct your point. Regards, -- Sin desafíos la vida es una rutina, una lenta agonía Diógenes Caraballo On Fri, Mar

Re: [ADMIN] vacuuming and reindexing

2009-03-21 Thread Tena Sakai
Hi Diógenes, Thanks for your response. do you also update rows of that table? because that action delete old one's and insert new one's.. Yes, I do. Here's the definition of the table: Table public.genotype Column |Type

Re: [ADMIN] pg_dump formatting

2009-03-21 Thread Caleb Cushing
On Sat, Mar 21, 2009 at 12:58 AM, Tom Lane t...@sss.pgh.pa.us wrote: What exactly do you find un-diffable about it? after doing a bit of testing to be more explicit... pg isn't half as bad as mysql, so I've mostly been asking about something that doesn't apply... however, it seems that it