Re: URGENT!!! changing Column size
От | Franco Bruno Borghesi |
---|---|
Тема | Re: URGENT!!! changing Column size |
Дата | |
Msg-id | 1067347729.756.0.camel@taz обсуждение исходный текст |
Ответ на | Re: URGENT!!! changing Column size (Theodore Petrosky <tedpet5@yahoo.com>) |
Ответы |
Re: URGENT!!! changing Column size
|
Список | pgsql-sql |
Dopping the whole database just for a column change? <br /><br /> On Tue, 2003-10-28 at 10:00, Theodore Petrosky wrote:<blockquote type="CITE"><pre><font color="#737373"><i>why not just pg_dump dbname > olddb.out pico olddb.out edit the section that defines the table save and exit dropdb dbname createdb dbname psql dbname < olddb.out no fuss no muss... Ted --- mohan@physics.gmu.edu wrote: > Hi can we change the size of a column in postgres. I > have a table named > institution and column name is name varchar2(25), i > want to change it to > varchar2(50). Please let me know. > > --Mohan > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears</i></font> <a href="http://launch.yahoo.com/promos/britneyspears/"><u>http://launch.yahoo.com/promos/britneyspears/</u></a> <font color="#737373"> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? </font><a href="http://www.postgresql.org/docs/faqs/FAQ.html"><u>http://www.postgresql.org/docs/faqs/FAQ.html</u></a> <font color="#737373"></font></pre></blockquote>
В списке pgsql-sql по дате отправления: