Re: Column duplication with \d in psql

Adam Witney wrote:
>
> Something strange has just appeared in my database, can anyone explain this
> duplication of columns:
>
> test=# \d plate_reporter
> Table "plate_reporter"
> Column | Type | Modifiers
> -------------------+---------+--------------------------------------------
> plate_reporter_id | integer | not null,
> plate_reporter_id | integer | not null,
> plate_id | integer | not null
> plate_id | integer | not null
> well_address | text | not null
> well_address | text | not null
> reporter_id | integer | not null
> reporter_id | integer | not null
> dilution_factor | text |
> dilution_factor | text |

What version of PostgreSQL are you using? Old versions could get
duplicates in some system tables. Do you have a two row for
'plate_reporter' in pg_class?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073