I have a php script that patches database, comparing pg_catalog's tables to
input files. One thing it can do, but I can't take responsibility ;) is
changing the type of a column.
It's basically the same that everyone wrote, except that I also examine
dependencies, as broad an examination as I coul
>
> On Tuesday 28 October 2003 08:28, Franco Bruno Borghesi wrote:
> > Dopping the whole database just for a column change?
>
> I guess some people have really small databases that don't take 3 days to dump
> and reload. :-)
>
And you are on the safe side regarding indexes, views, procedures,
On Tuesday 28 October 2003 08:28, Franco Bruno Borghesi wrote:
> Dopping the whole database just for a column change?
I guess some people have really small databases that don't take 3 days to dump
and reload. :-)
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves
h
Dopping the whole database just for a column change?
On Tue, 2003-10-28 at 10:00, Theodore Petrosky wrote:
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..
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
--- [EMAIL PROTECTED] wrote:
> Hi can we change the size of a column in postgres. I
> have a table named
>
Hi,
[EMAIL PROTECTED] wrote, On 10/27/2003 6:10 PM:
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.
1 solution:
begin;
create temporary table temp as select * from m
Dnia 2003-10-27 19:33, Użytkownik [EMAIL PROTECTED] napisał:
I've seen these sets of steps suggested in response to other such
inquires, but doesn't this break views on the associated table, or may
just not work because if a view dependency exists?
It would be the second case (it won't work at all)
On Monday 27 Oct 2003 5:10 pm, [EMAIL PROTECTED] 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
try
alter table institution add column newn
Dnia 2003-10-27 18:10, Użytkownik [EMAIL PROTECTED] napisał:
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.
alter table institution add column tmp varchar2(50);
update
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
10 matches
Mail list logo