Re: Copy/Paste table(s) functions - Mailing list pgadmin-hackers

From Vladimir Kokovic
Subject Re: Copy/Paste table(s) functions
Date
Msg-id BANLkTinyTqbyeCrggj6FPKqQ6AVfLp51og@mail.gmail.com
Whole thread Raw
In response to Re: Copy/Paste table(s) functions  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Copy/Paste table(s) functions  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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

pgadmin-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Copy/Paste table(s) functions
Next
From: Erwin Brandstetter
Date:
Subject: Re: 1.12.3 built