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