X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 5860CD1B529
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Oct 2003 13:29:25 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 91340-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Oct 2003 09:28:56 -0400 (AST)
Received: from lucifer.oficina (unknown [200.69.203.237])
	by svr1.postgresql.org (Postfix) with ESMTP id C3D0AD1B51A
	for <pgsql-sql@postgresql.org>; Tue, 28 Oct 2003 09:28:51 -0400 (AST)
Received: from [192.168.1.190] (taz.oficina [192.168.1.190])
	(authenticated bits=0)
	by lucifer.oficina (8.12.9/8.12.9) with ESMTP id h9SDSlfv044639;
	Tue, 28 Oct 2003 10:28:47 -0300 (ART)
	(envelope-from franco@akyasociados.com.ar)
Subject: Re: URGENT!!! changing Column size
From: Franco Bruno Borghesi <franco@akyasociados.com.ar>
To: Theodore Petrosky <tedpet5@yahoo.com>
Cc: mohan@physics.gmu.edu, pgsql-sql@postgresql.org
In-Reply-To: <20031028130052.54133.qmail@web41010.mail.yahoo.com>
References: <20031028130052.54133.qmail@web41010.mail.yahoo.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-EeiMVl07+JtajYI18Usk"
Organization: AK y Asociados S.R.L.
Message-Id: <1067347729.756.0.camel@taz>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.4 
Date: Tue, 28 Oct 2003 10:28:50 -0300
X-MailScanner-Information: Please contact the ISP for more information
X-MailScanner: Found to be clean
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/359
X-Sequence-Number: 15759

--=-EeiMVl07+JtajYI18Usk
Content-Type: multipart/alternative; boundary="=-sK4nkcNH8X7N8X3fj8us"

--=-sK4nkcNH8X7N8X3fj8us
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Dopping the whole database just for a column change?=20

On Tue, 2003-10-28 at 10:00, Theodore Petrosky wrote:

> why not just
>=20
> pg_dump dbname > olddb.out
> pico olddb.out
>=20
> edit the section that defines the table
> save and exit
>=20
> dropdb dbname
> createdb dbname
>=20
> psql dbname < olddb.out
>=20
> no fuss no muss...
>=20
> Ted
>=20
> --- 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.
> >=20
> > --Mohan
> >=20
> >=20
> >=20
> >=20
> >=20
> >=20
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> > unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>=20
> __________________________________
> Do you Yahoo!?
> Exclusive Video Premiere - Britney Spears
> http://launch.yahoo.com/promos/britneyspears/
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
>                http://www.postgresql.org/docs/faqs/FAQ.html
>=20

--=-sK4nkcNH8X7N8X3fj8us
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; CHARSET=3DUTF-8">
  <META NAME=3D"GENERATOR" CONTENT=3D"GtkHTML/3.0.8">
</HEAD>
<BODY>
Dopping the whole database just for a column change? <BR>
<BR>
On Tue, 2003-10-28 at 10:00, Theodore Petrosky wrote:
<BLOCKQUOTE TYPE=3DCITE>
<PRE><FONT COLOR=3D"#737373"><I>why not just

pg_dump dbname &gt; olddb.out
pico olddb.out

edit the section that defines the table
save and exit

dropdb dbname
createdb dbname

psql dbname &lt; olddb.out

no fuss no muss...

Ted

--- mohan@physics.gmu.edu wrote:
&gt; Hi can we change the size of a column in postgres. I
&gt; have a table named
&gt; institution and column name is name varchar2(25), i
&gt; want to change it to
&gt; varchar2(50). Please let me know.
&gt;=20
&gt; --Mohan
&gt;=20
&gt;=20
&gt;=20
&gt;=20
&gt;=20
&gt;=20
&gt; ---------------------------(end of
&gt; broadcast)---------------------------
&gt; TIP 2: you can get off all lists at once with the
&gt; unregister command
&gt;     (send &quot;unregister YourEmailAddressHere&quot; to majordomo@pos=
tgresql.org)

__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears</FONT>
<A HREF=3D"http://launch.yahoo.com/promos/britneyspears/"><U>http://launch.=
yahoo.com/promos/britneyspears/</U></A>
<FONT COLOR=3D"#737373">
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               </FONT><A HREF=3D"http://www.postgresql.org/docs/faqs/FAQ.ht=
ml"><U>http://www.postgresql.org/docs/faqs/FAQ.html</U></A>
<FONT COLOR=3D"#737373"></I></FONT></PRE>
</BLOCKQUOTE>
</BODY>
</HTML>

--=-sK4nkcNH8X7N8X3fj8us--

--=-EeiMVl07+JtajYI18Usk
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/nm8R21dVnhLsBV0RAsbvAJ42zeib3kZYQvRRImLJxjK0A7+hhgCfS/Qv
p3jhR7vxDfA2St0mwo2BnAc=
=NdwW
-----END PGP SIGNATURE-----

--=-EeiMVl07+JtajYI18Usk--