pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: Re: alter column witdh
Date: Tue, 27 May 2003 11:17:20 -0400
Message-ID: <5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca> (raw)
In-Reply-To: <016901c3245d$b1a820d0$0701a8c0@netterm>
References: <001101c31fb8$ebdb30c0$0701a8c0@netterm>
	<3ECE195A.7060209@Yahoo.com>
	<004901c3212e$8919fda0$0701a8c0@netterm>
	<3ECFE017.7060800@Yahoo.com>
	<00e001c32453$2f8f45b0$0701a8c0@netterm>
	<15000.1054045212@sss.pgh.pa.us>

At 10:38 AM 5/27/03, Eric Anderson Vianet SAO wrote:
 >how can I alter the column width

http://techdocs.postgresql.org/techdocs/updatingcolumns.php

fbax=# create table tablename (columnname text);
CREATE
fbax=# \d tablename
       Table "tablename"
  Attribute  | Type | Modifier
------------+------+----------
  columnname | text |

fbax=# \q

pg_dump -o -c -s -t tablename fbax | sed "s:\"columnname\" 
text:\"columnname\" varchar(2):" | psql

Frank 

view thread (3+ messages)

Message-ID: <5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca>
Permalink:  ../5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca/
Also on:    postgresql.org/message-id/5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: fbax@sympatico.ca
  Subject: Re: alter column witdh
  In-Reply-To: <5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox