Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

changing a definition in a dump file?

Поиск
Список
Период
Сортировка
От postgresql
Тема changing a definition in a dump file?
Дата
Msg-id 200201181627.g0IGRTV91993@postgresql.org
обсуждение исходный текст
Ответы Re: changing a definition in a dump file?
Conditionally create table problem
Список 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 по дате отправления: