pg_restore or copy. look in the documentation. I import data from flat files usually this way:
psql dbname < file The file contains a line before the data: COPY "tablename" FROM stdin; data.... \. If your delimiter is something other than tab you must specify the delimiter type this way: COPY "tablename" FROM stdin USING DELIMITERS '|'; # this is using | as the delimiter. On Wed, 2002-02-13 at 14:00, Pam Wampler wrote: > Is there a postgresql utility to load data from a flat file? Similar to > oracle sqlldr? > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Jeff Self Information Technology Analyst Department of Personnel City of Newport News 2400 Washington Ave. Newport News, VA 23607 757-926-6930 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
