Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group