I created two tables with a primary key and needed to replicate them, ie put them in another database but all on the same machine. How should I do this?
The tables created are these:
CREATE TABLE cities1 (
city varchar(80) primary key,
location point
);
CREATE TABLE weather10 (
city varchar(80) references cities1(city),
temp_lo int,
temp_hi int,
prcp real,
date date
)
INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27');//insere uma linha na tabela com os dados
INSERT INTO cities VALUES ('San Francisco', '(-194.0, 53.0)');