Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
From postgreSql dump to MySql...
I found a software that make postgres dump... That's the sql generated: CREATE TABLE "amici" ( "id" INTEGER NOT NULL, "versione" CHAR(3) NOT NULL, "titolo" VARCHAR(50) DEFAULT '', "testo" TEXT DEFAULT '', UNIQUE("id"...- crixo
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
From postgreSql dump to MySql...
How can convert a postgres sql dump script to a valid script for MySql?? I use pg_dump to generate a sql script and ai want convert this to load my db on mySql... Exist a tools that can make this??- crixo
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
-
How Procedure return a recordset
Hi! Who can send me an expample of a postgres stored procedure that return a recordset.... I found this syntax: ---------------------------- CREATE FUNCTION reffunc2() RETURNS refcursor AS' DECLARE ref refcursor; BEGIN OPEN ref FOR SELECT * FROM t1; RETURN ref; END...- crixo
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
