pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
About 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>
  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 14:45  Mark Stosberg <mark@summersault.com>
  parent: David BOURIAUD <david.bouriaud@ac-rouen.fr>
  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 15:28  Peter Eisentraut <peter_e@gmx.net>
  parent: David BOURIAUD <david.bouriaud@ac-rouen.fr>
  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