You can use:
COPY table_1 FROM '/usr/file.txt' USING DELIMITERS '/';
table_1 (f1 INT4, f2 VARCHAR(20));
file:
0/aaaa
1/bbbb
Fernando Caamaño wrote:
>
> Hi all, I'm quite new in postgres, and I can't find how can i do this.
> I have a txt file with all de data of one table, and I want to insert it
> into the database. in mysql is load data infile ....
> how is in postgres?
> thank you
> Fernando Caamaño
> Programador web
> Interweb Research
> www.interweb-research.net