hu js написа: > run: > "CREATE TABLE xxx > ( > id serial NOT NULL, > name character varying > ); > insert into xxx select default values,place_name from air_bui;"
insert into xxx (name) select place_name from air_bui; > > fail: > "ERROR: syntax error at or near "default" > SQL state: 42601 > Character: 24" > -- Milen A. Radev ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate