in reply to Re: xl file to database
in thread xl file to database
You can also copy a table to a file. This may not be available through DBI but you can always create the file and then system "psql < file_to_copy_in";.db=> \h COPY Command: COPY Description: copy data between files and tables Syntax: COPY table [ ( column [, ...] ) ] FROM { 'filename' | stdin } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'delimiter' ] [ NULL [ AS ] 'null string' ] ]
--tidiness is the memory loss of environmental mnemonics
|
|---|