[SQL] I, nead to capture the IP number from the PC how is running the script ...

I, nead to capture the IP number from the PC how is running the script "update TABLE1 set campo1 = 123 where ...; " Can someone help me please? -- John Evan Dizaro - Fone: (41) -0303 Fone: (41) 9243-3240 Rua: Alferes Poli Curitiba - PR - Brasil

[SQL] Pgadmin hotkeys?

Can somebody tell me please where i can find the PgAdmin Hotkey like Ctrl+SPACEBAR and others?? Tanks for all. -- John Evan Dizaro - Fone: (41) -0303 Fone: (41) 9243-3240 Rua: Alferes Poli Curitiba - PR - Brasil

[SQL] how to update 400 000 register not at the same time?

I Have um very big table with primary key and all i nead. When i update same register from this table it comes sj=low. Can i Update all my 400 000 register not at the same time? By steps? Thanks -- John Evan Dizaro Software - Fone: (41) -0303 Fone: (41) 9243-3240 Rua: Alferes Poli Curit

Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

desenpenho. Obrigado 2008/11/20 John Dizaro <[EMAIL PROTECTED]> > I have to execute some times an UPDATE an some times a DELETE to > register +- 5 , every time when i do that the database be to slow > do we any way to DELETE or UPDATE by part??? > Thanks > &g

Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

The problem is ... how to run the SCRIPT to the few? not all the 5 lines of "update" at the same time. John Evan Dizaro 2008/11/20 John Dizaro <[EMAIL PROTECTED]> > I have to execute some times an UPDATE an some times a DELETE to > register +- 5 , every ti

[SQL] UPDATE and DELEte with a lot of register is to slow...

I have to execute some times an UPDATE an some times a DELETE to register +- 5 , every time when i do that the database be to slow do we any way to DELETE or UPDATE by part??? Thanks -- John Evan Dizaro -