Обсуждение: importing csv files into v7.2.1 on Solaris 8 x86
Hi, I recently compiled PostgreSQL v7.2.1 under Solaris 8 x86 (July 2001) in order to use it to hold the contents of Firewall logs. I have automated the Firewall log creation process and got them delivered to the intended database server as csv text files. I have compiled v7.2.1 (straight forward if you just include C, C++ support) but now need to write a program to accept the csv log file and enter the record information. Some newbie questions. Is their a utility which will read a database table definition and automatically import a csv format file expecting the fields to be in the correct order as the table? I remember that Progress (c 1994) can dump its database definition and database as text files which can then be read by another version of Progress to automatically recreate the database tables and populate the tables. Can anyone recommend the best way to perform a backup of PostgreSQL on Solaris. Can I just shutdown PostgreSQL and perform a ufsdump of the disk on which postgreSQL resides and restore onto a different disk or server as necessary? Regards Russell
On Thu, 25 Apr 2002 09:13:10 +0100 "Russell Aspinwall" <russell.aspinwall@flomerics.co.uk> wrote: > Is their a utility which will read a database table definition and > automatically import a csv format file expecting the fields to be in the > correct order as the table? Yes -- take a look at COPY, and/or the psql \copy command. The syntax is something like: COPY target_table FROM '/your/csv/file' USING DELIMITERS ','; Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC