Thread: insert a file into remote database

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: 843-792-1555 (O)
Fax: 843-876-1126

On Mon, Oct 18, 2004 at 15:37:48 -0400,
  Chuming Chen <chen@musc.edu> wrote:
> 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.