Subject: Re: Insert a description while creating a table
From: Rod Taylor <rbt@rbt.ca>
To: luiz@klais.com.br
Cc: pgsql-sql@postgresql.org
In-Reply-To: <Pine.LNX.4.44.0308130851230.1254-100000@elessar.klais>
References: <Pine.LNX.4.44.0308130851230.1254-100000@elessar.klais>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-eOXpDDNudfeSbXNWIX5+"
Message-Id: <1060776408.86938.12.camel@jester>
Mime-Version: 1.0
Date: Wed, 13 Aug 2003 08:06:49 -0400

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

On Wed, 2003-08-13 at 07:56, luiz@klais.com.br wrote:
> Hi,
>=20
> I want to insert descriptions at the columns of my tables but without=20
> using the command COMMENT ON. I want to do it together with the table=20
> creation. Is that possible?
>=20
> I wanna do something like this:
>=20
> create table test (
> 	id serial 'Descripitions about ID',
> 	name varchar(50) 'Descriptions about NAME'
> );

Probably not going to happen in the backend.

However, you should be able to accomplish that with a little bit of Perl
to pre-process the SQL.

--=-eOXpDDNudfeSbXNWIX5+
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/OinY6DETLow6vwwRAnZZAKCFqNH5H70B/7YXqP+hjEhkKwHoAQCfdoRZ
KUHThSFVadz0nY/K1dXAYj8=
=2vmj
-----END PGP SIGNATURE-----

--=-eOXpDDNudfeSbXNWIX5+--