Firebird copy a table
lazarus / 16-Databases

----------------------------------------------------------------------
TRNelson · 2016-02-17 19:30

I would like to copy all or some of the columns from one table to
another.  I can use an SQL command similar to

INSERT INTO newtable SELECT columns FROM oldtable;

Is there a way to do this using a stored procedure in order to have
this happen on the server side and not client side? 

I am not generally worried about the wear and tear on the server and
need to reduce the amount of server/client traffic as much as
possible.  It is my understanding the at the SQL Insert command above
will copy all the data to the client and send it back to the server
into the target table.  Hoping to avoid that.

----------------------------------------------------------------------
taazz · 2016-02-17 19:49

Quote from: TRNelson on February 17, 2016, 08:30:43 pmI would like to
copy all or some of the columns from one table to another.  I can use
an SQL command similar to

INSERT INTO newtable SELECT columns FROM oldtable;

Is there a way to do this using a stored procedure in order to have
this happen on the server side and not client side? 

I am not generally worried about the wear and tear on the server and
need to reduce the amount of server/client traffic as much as
possible.  It is my understanding the at the SQL Insert command above
will copy all the data to the client and send it back to the server
into the target table.  Hoping to avoid that.
Not really the insert into .. select ... is a server side command the
data never reach the client that issued that command.

----------------------------------------------------------------------
TRNelson · 2016-02-17 21:25

Quote from: taazz on February 17, 2016, 08:49:15 pmNot really the
insert into .. select ... is a server side command the data never
reach the client that issued that command.
I thought that may be the case but recently I came to doubt that.  If
this is the case, then I have my answer.

Thanks!

----------------------------------------------------------------------
taazz · 2016-02-18 01:59

Quote from: TRNelson on February 17, 2016, 10:25:03 pmQuote from:
taazz on February 17, 2016, 08:49:15 pmNot really the insert into ..
select ... is a server side command the data never reach the client
that issued that command.
I thought that may be the case but recently I came to doubt that.  If
this is the case, then I have my answer.

Thanks!
As far as I know this is the case. What makes you doubt that?