Re: [SQL] Re: Informix->PostgreSQL database convertion

2001-05-14 Thread rmcm
is there an informix utility called dbschema which does this? dbschema -t all -d databasename > schema.sql Sylte writes: > How is the SQL command UNLOAD (informix) used to extract both data and > database architecture? > > Is it able to create a file of SQL statements like when using pos

[SQL] Re: Informix->PostgreSQL database convertion

2001-05-12 Thread Sylte
How is the SQL command UNLOAD (informix) used to extract both data and database architecture? Is it able to create a file of SQL statements like when using postgresql's command "pg_dump -f outputfile mydb" ---(end of broadcast)--- TIP 6: Have yo

[SQL] Re: Informix->PostgreSQL database convertion

2001-05-11 Thread Sylte
It is convertion of the data, not the application... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing li

[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