longlong wrote: > I want to transmit data from a database to another partly, > which means only data that selected in a table will be transmit. > > I can select data , and then inert or update rows one by one. > But is there any way better? You can export part of a table with COPY (sql query) TO 'file' and import it into another database with another COPY statement. Is that what you need? Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster