[SQL] Re: SELECT * INTO TABLE is not working for me.

2001-06-05 Thread Sergey E. Volkov
"Roy Souther" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: 0105301102010Q.28903@OlympusMons">news:0105301102010Q.28903@OlympusMons... > I am testing my SQL commands in pgaccess before I put them into my C++ code. > Trying to copy a table using... > SELECT * INTO TABLE copy_stuff FROM

[GENERAL] Re: Return cursor

2001-05-28 Thread Sergey E. Volkov
If you are planing to use ecpg : exec sql declare cuserbase cursor for select column1, column2, column3 from my_table order by 1; exec sql open cuserbase; exec sql whenever not found do break; while ( true ) { exec sql fetch cuserbase into ... // do same work } exec sql close cuserb

[SQL] Re: Informix->PostgreSQL database convertion

2001-05-11 Thread Sergey E. Volkov
I think this isn't so difficult. Use "unload to ..." on Informix side ( from dbaccess ) and "copy ... from ..." om Postgres side. "Sylte" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: 9d8r7v$1to$[EMAIL PROTECTED]">news:9d8r7v$1to$[EMAIL PROTECTED]... > Howto? Are there tools or is i

[SQL] Same question about PostgreSql

2001-04-14 Thread Sergey E. Volkov
Hi group, We have a DSS system based on Informix IDS and number of OLTP systems based on Interbase. After we was running this system, we had have a unceasing serious problems with Interbase. 1) Massive inserts, updates, deletes is crashed database internal structure !!!. we have to make backup