insert a file into remote database

[Chuming Chen]

Hi, all,

Is there anyway to insert a local text file into a table in a remote
database server?

Thanks,
--
Chuming Chen
System Administrator & Programmer
Department of Biostatistics, Bioinformatics and Epidemiology
Medical University of South Carolina
135 Cannon Street, Suite 303
Charleston SC 29425
Tel: [phone] (O)
Fax: [phone]



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Bruno Wolff III]

On Mon, Oct 18, 2004 at 15:37:48 -0400,

Post by Chuming Chen
Hi, all,
Is there anyway to insert a local text file into a table in a remote
database server?

Perhaps psql's \copy command will do what you want.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend