7.3.x (phppgadmin) data migration to 7.4.x (pgadmin3) issue

From: <operationsengineer1(at)yahoo(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: 7.3.x (phppgadmin) data migration to 7.4.x (pgadmin3) issue
Date: 2005-09-13 17:07:01
Message-ID: 20050913170701.62014.qmail@web33305.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

phppgadmin (my only access to db - cheesy webhost) has
an "export" link that only allows me to...

export data, structure or data and structure (fine so
far, i want data only).

format options are "copy" and "sql".

i can also check "oid" and/or "drop", but i don't
think either apply to my case since i don't use oids
as primary keys.

i can download the data or i can download a compressed
copy of the data.

i tried data only and downloaded with the sql options.

i plugged this into pgadmin's query view and ran it.
unfortunately, the sql doesn't list the column names
in the insert statements... and my columns are not
all in the same order! so close... yet still so
far....

is there anything i can do here? i don't think
pgadmin allows me to reorder columns. therefore, i
don't like that approach (deleting and recreating a
lot of columns and handling all the contrainsts,
etc...).

i don't fully understand how to restore the output of
the "copy" option. when i try and restore something
in pgadmin3, it is looking for a file with extension
*.backup. i don't think phppgadmin (as set up on
cheesy webhost) allows me to create this type of file.

any guidance would be appreciated - as always.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-09-13 17:44:30 Re: psql, pg_dumpall, remote server questions...
Previous Message Keith Worthington 2005-09-13 16:00:54 Joining a series of dates