changing a definition in a dump file? - Mailing list pgsql-sql

From postgresql
Subject changing a definition in a dump file?
Date
Msg-id 200201181627.g0IGRTV91993@postgresql.org
Whole thread Raw
Responses Re: changing a definition in a dump file?
Conditionally create table problem
List 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




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: pltlc and pltlcu problems
Next
From: Stephan Szabo
Date:
Subject: Re: changing a definition in a dump file?