> 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.