Well, since it is already in text format, just load it normally: psql <database name> -f 20020422_project_summaries.gz
psql doesn't care what the name is so long as the internal format is OK. If you want to, you can rename it. (I probably would to avoid confusion among the humans.) -Nick -------------------------------------------------------------------------- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] > Sent: Monday, June 24, 2002 10:30 AM > To: [EMAIL PROTECTED] > Subject: [ADMIN] Importing Database > > > Hi, > > I'm trying to import this database into postgresql. > The file is called 20020422_project_summaries.gz. > When I gunzip it, I get: > > postgres@E52BPS588R /Databases > $ gunzip 20020422_project_summaries.gz > > gunzip: 20020422_project_summaries.gz: not in gzip format > > 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. > > Alex > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
