db & table names

From: Liz Pelletier <liz(at)plandepot(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: db & table names
Date: 2001-07-16 16:30:24
Message-ID: 3B5316A0.8270B819@plandepot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I dumped a 7.0 db on a RedHat box, createdb'd the db on a new debian box
sporting 7.1, ftp'd the dumped file and restored. Everything seemed to
go fine, except the names of the db and the tables are numeric
expressions instead of the actual table names. For instance, a db named
mydb containing tables table1 and table2 now appears on the new box as
db named 6432466 with tables 6432512 and 6432513. What?? Did I not
install postgresql correctly, miss an environment variable or is this
how the table names are held in the file system on debian boxes? It is
important that I know the file system name for tables as I overwrite
certain tables that are imported from a foxpro table and converted using
dbf2pg. Any guidance here would be greatly appreciated.

Thanks,
Liz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2001-07-16 16:36:53 Re: html to postgres...
Previous Message Richard Huxton 2001-07-16 16:26:48 Re: html to postgres...