Skip site navigation (1) Skip section navigation (2)

Re: Subset edit data view

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: mdoggett(at)coas(dot)oregonstate(dot)edu,"[pgADMIN]" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Subset edit data view
Date: 2004-02-10 19:26:00
Message-ID: 40293048.7010903@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Matt Doggett wrote:

>I've been using pgaccess for a while and decided to give pgadmin a try
>and see how it compares, so I'm new here.
>  One thing I'd like to do is be able to interactively edit data in the
>database.  I notice that pgadmin offers a "view data" where you can do
>this, and that's great. However, I have some data tables that contain
>millions of records in them.  And, as far as I can tell, pgadmin will
>try to load the ENTIRE table to view (which takes a ridiculous amount of
>time). 
>
No, it does only load the displayed data.

>Is there any way to control this?  In pgacess you could limit the
>records that were displayed for editing with simple constraints like in
>an SQL WHERE clause. 
>
1.1 has a filter option.

Regards,
Andreas



In response to

pgadmin-support by date

Next:From: Dave PageDate: 2004-02-10 20:28:53
Subject: Re: snapshot for XP crashes on show properties
Previous:From: Steve FoxDate: 2004-02-10 18:26:56
Subject: snapshot for XP crashes on show properties

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group