Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0IGRTV91993 for ; Fri, 18 Jan 2002 11:27:29 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200201181627.g0IGRTV91993@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Fri, 18 Jan 2002 11:42:31 -0500 Date: Fri, 18 Jan 2002 11:42:31 -0500 From: "postgresql" To: "PgSQL-SQL" Subject: changing a definition in a dump file? MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200201/219 X-Sequence-Number: 6303 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