Re: how can I tell it's postgresql data?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ricardo Anguiano <anguiano(at)codesourcery(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how can I tell it's postgresql data?
Date: 2003-02-06 14:49:17
Message-ID: 12217.1044542957@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ricardo Anguiano <anguiano(at)codesourcery(dot)com> writes:
> I have recently been given some files and told they were "postgre SQL
> database" files. I have a couple of questions.

If the files contain text then they're probably dump scripts to feed to
psql. They might also have been non-text pg_dump archives, but you seem
to have tried that possibility already. The only other possibility is
that someone thought they could give you raw table files out of the
database innards ... in which case you'll have to go back to them and
ask for a proper pg_dump dump. You cannot stick raw table files into
another installation.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Dinesh Visweswaraiah 2003-02-06 15:17:15 Re: SQL Intersect like problem
Previous Message Wim 2003-02-06 10:54:59 Re: Postgres performace with large tables.