Re: [SQL] Comparing two tables of different database

2009-05-02 Thread Lucas Brito
e_Name text, Column_Name text) on ST.Table_Name = DV.Table_name and ST.Column_Name = DV.Column_Name where ST.Column_Name is null or DV.Column_Name is NULL -- Lucas Brito

Re: [SQL] Comparing two tables of different database

2009-05-02 Thread Lucas Brito
dblink(db_database1(), 'select "id", "name", "time" from pr_1') as pr_1("id" integer, "name" text, "time" time) then you will see the table "pr_1" on the datbase2 -- Lucas Brito