changing a definition in a dump file?

From: "postgresql" <pgsql(at)symcom(dot)com>
To: "PgSQL-SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: changing a definition in a dump file?
Date: 2002-01-18 16:42:31
Message-ID: 200201181627.g0IGRTV91993@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,
I think I inadvertently sent this to pg-admin...

Is it possible to change the definitions in the dump file to alter a
table.

this is from my  pgdump file:

CREATE TABLE "fc_client_info" (
   "acode" character varying(12),
   "cname" character varying(32)
);

If I change the file to read:

CREATE TABLE "fc_client_info" (
   "acode" character varying(12),
   "cname" character varying(128)
);

Can I drop the database and read in the altered pgdump file to effect the
change?

Thanks for your time.

Ted

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-01-18 16:59:48 Re: changing a definition in a dump file?
Previous Message Tom Lane 2002-01-18 15:04:41 Re: pltlc and pltlcu problems