How to edit select result without using update statment

[sapir azulay]

Hi all,
Is somebody know how can I edit some query result easily without using Update command?

In oracle I use it:
select r.*,rowid from dw_articles r where..


Thanks a lot!

[JimKnicely]

Hi,

Sorry but I don't understand your question

What do you mean by "edit"? Do you mean view?

If you just want to view the data in the table, run the same query in Vertica, except leave out the rowid pseudo-column.

select r.* from dw_articles r where..

Or do you need to change (i.e. update) row values?

[sapir azulay]

Hi,
Thanks for your respond,
I want to edit the data in the table.
I can do it by this Updare statement:

update Table_name set column_name=10 where..

But I want to be able to update manually while I'm looking the data
In Oracle I used to use Toad Application, there when you write the select statement with the row_id , you may change the shown data

[JimKnicely]

Hi,

Now I understand

There is a freeware version of Toad called "Toad for Data Analysts Freeware v3.0" that is compatible with Vertica. It has a data grid that allows you to edit tables data.

You can download it from here:

http://www.toadworld.com/m/freeware/547.aspx