kopie tabulky z jedne do druhe databaze

[Milan Kerslager]

On Fri, 1 Sep 2000, Moser Radovan wrote:

> Jedna se o PostgreSQL.

PostgreSQL v podstate splnuje SQL92, takze otevru knizku o SQL a ctu:

INSERT INTO new SELECT * FROM old;

lze doplnit i o klauzuli WHERE. Pripadne (misto ALTER TABLE ... DROP
sloupec):

CREATE TABLE temp AS SELECT did, city FROM distributors;    
DROP TABLE distributors;
CREATE TABLE distributors (
  did      DECIMAL(3)  DEFAULT 1,
  name     VARCHAR(40) NOT NULL,
);
INSERT INTO distributors SELECT * FROM temp;
DROP TABLE temp;

:-) jak proste mily Watsone ;-)

--
                        Milan Kerslager
                        E-mail: milan.kerslager na spsselib.hiedu.cz
                        WWW:    http://www.spsselib.hiedu.cz/~kerslage/