Обсуждение: Can I write "live" queries in pgadmin?

Поиск
Список
Период
Сортировка

Can I write "live" queries in pgadmin?

От
durumdara@gmail.com
Дата:
Hi!

I search for "live" query option in pgadmin, where I can update the requested data in the editor.

Or pgadmin doesn't supports this function yet?

Best wishes: dd



Re: Can I write "live" queries in pgadmin?

От
Raymond O'Donnell
Дата:
On 14/11/2012 15:15, durumdara@gmail.com wrote:
> Hi!
> 
> I search for "live" query option in pgadmin, where I can update the requested data in the editor.
> 
> Or pgadmin doesn't supports this function yet?

Sure - just press F5, or hit the "Run" button again.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



Re: Can I write "live" queries in pgadmin?

От
Raymond O'Donnell
Дата:
On 15/11/2012 07:00, durumdara@gmail.com wrote:
> Hi!
> 
> Maybe we are talking about other thing.
> 
> I'm talking about live result set, what is editable.
> Many data manager supports that - when I write a query what is using
> only one table (select * from test), then the result set is "live" kind.
> This meaning that I can edit the data directly in the grid, or in other
> controls, and when I save it, this record written into database by manager.
> Like "Edit data" function in pgadmin, but with more flexibility: I can
> use subqueries to filter the records by any criteria except complex queries.
> 
> But as I see the Data Grid is readonly here...

[Copying back to the list]

Ah, yes, I misunderstood you. No, you can't do that in pgAdmin.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie