> When I type less 20020422_project_summaries.gz, I get the > text of the database of this file. So it seems that it's already unzipped > but has the .gz extension. how do I import this file > as a database into postgresql? I'm running cygwin and pgAdmin II > on a win2k computer. >
I am no w2k or cygwin expert, but you could try: cd /dir/where/20020422_... exists psql create database my_new_db; \c my_new_db \i 20020422_project_summaries.gz This sort of assumes that file is from pg_dump and is not just a csv (or some other format) of plain data. If it is just data, you would need to create your table structure, then \copy or COPY the data in to the tables. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
