pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAbout table column names.
3+ messages / 3 participants
[nested] [flat]
* About table column names.
@ 2001-06-07 08:57 David BOURIAUD <david.bouriaud@ac-rouen.fr>
2001-06-07 14:45 ` Re: About table column names. Mark Stosberg <mark@summersault.com>
2001-06-07 15:28 ` Re: About table column names. Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 3+ messages in thread
From: David BOURIAUD @ 2001-06-07 08:57 UTC (permalink / raw)
To: pgsql-sql
Hi the list !
As far as I know, column names for a table can't contain any space,
tabs, and other sort of "exotic" characters. Is there a way to add a
description of a table column anywhere in postgres tables, or does it
have to be handled manually by creating a custum table handling this
kind of datas ? Thanks by advance for any suggestion.
--
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have
for windows or gates ?
----------------------------------------------------------
ICQ#102562021
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: About table column names.
2001-06-07 08:57 About table column names. David BOURIAUD <david.bouriaud@ac-rouen.fr>
@ 2001-06-07 14:45 ` Mark Stosberg <mark@summersault.com>
1 sibling, 0 replies; 3+ messages in thread
From: Mark Stosberg @ 2001-06-07 14:45 UTC (permalink / raw)
To: David BOURIAUD <david.bouriaud@ac-rouen.fr>; +Cc: pgsql-sql
David BOURIAUD wrote:
>
> Hi the list !
> As far as I know, column names for a table can't contain any space,
> tabs, and other sort of "exotic" characters.
In fact, I know you can have at least spaces in your column names, like this:
mark=> create table t ("column one" text);
CREATE
Just put quotes around them.
> Is there a way to add a
> description of a table column anywhere in postgres tables, or does it
> have to be handled manually by creating a custum table handling this
> kind of datas ? Thanks by advance for any suggestion.
I'm interested in this, too. It seems more useful than having them in a
SQL file...which can sometimes get out of synch with the database. :)
-mark
http://mark.stosberg.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: About table column names.
2001-06-07 08:57 About table column names. David BOURIAUD <david.bouriaud@ac-rouen.fr>
@ 2001-06-07 15:28 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2001-06-07 15:28 UTC (permalink / raw)
To: David BOURIAUD <david.bouriaud@ac-rouen.fr>; +Cc: pgsql-sql
David BOURIAUD writes:
> Is there a way to add a description of a table column anywhere in
> postgres tables,
COMMENT ON COLUMN table.col IS 'whatever';
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-06-07 15:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-07 08:57 About table column names. David BOURIAUD <david.bouriaud@ac-rouen.fr>
2001-06-07 14:45 ` Mark Stosberg <mark@summersault.com>
2001-06-07 15:28 ` Peter Eisentraut <peter_e@gmx.net>
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