Re: Copy/Paste table(s) functions

From: Vladimir Kokovic <vladimir(dot)kokovic(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Copy/Paste table(s) functions
Date: 2011-04-18 09:04:03
Message-ID: BANLkTinyTqbyeCrggj6FPKqQ6AVfLp51og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

1.Select server
2.Select database
3.select schema
4.select table with primary key which contains character varying.field
5.look in SQL pane line for the primary key definition
If your selected server is PostgreSQL 9.1, primary key looks like:
CONSTRAINT edi_razmena_pkey PRIMARY KEY (godina COLLATE
pg_catalog."default", razmena_id COLLATE pg_catalog."default", kupac
COLLATE pg_catalog."default")
6.If you apply patch, primary key looks like:
CONSTRAINT edi_razmena_pkey PRIMARY KEY (godina, razmena_id, kupac)

Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Erwin Brandstetter 2011-04-18 16:06:24 Re: 1.12.3 built
Previous Message Guillaume Lelarge 2011-04-18 07:33:09 Re: Copy/Paste table(s) functions