Feedback-ID: i76984098:Fastmail
Message-ID: <d65d25c5-b511-4a9a-92ed-16a27797ac57@aklaver.com>
Date: Wed, 20 Aug 2025 16:00:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: MS SQL to Postgres
To: Avinash Vallarapu <avinash.vallarapu@gmail.com>,
 KK CHN <kkchn.in@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAKgGyB8ZZLzDVg3eCym=BMf7+8LOS-bfOE1EdXWA_X4qha_=Xw@mail.gmail.com>
 <CAN0Tujf=C=hKL1ZOmKjGvsYc9f6L44iuE9ci0KnROJG8hrnA+w@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAN0Tujf=C=hKL1ZOmKjGvsYc9f6L44iuE9ci0KnROJG8hrnA+w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/d65d25c5-b511-4a9a-92ed-16a27797ac57%40aklaver.com>
Precedence: bulk

On 8/20/25 15:52, Avinash Vallarapu wrote:
> Hi Krishane,
> 

>   * SQL Server often auto-generates constraint names, while PostgreSQL
>     typically requires explicit
>     names.

You will need to give more detail on above as:

create table constraint_test (id integer primary key, fld_1 varchar, 
fld_2 varchar check (fld_2 != ''), UNIQUE(fld_1, fld_2));

constraint_test
                Table "public.constraint_test"
  Column |       Type        | Collation | Nullable | Default
--------+-------------------+-----------+----------+---------
  id     | integer           |           | not null |
  fld_1  | character varying |           |          |
  fld_2  | character varying |           |          |
Indexes:
     "constraint_test_pkey" PRIMARY KEY, btree (id)
     "constraint_test_fld_1_fld_2_key" UNIQUE CONSTRAINT, btree (fld_1, 
fld_2)
Check constraints:
     "constraint_test_fld_2_check" CHECK (fld_2::text <> ''::text)

> Regards,
> Avinash Vallarapu
> +1-902-221-5976
> www.hexarocket.com <http://www.hexarocket.com>


-- 
Adrian Klaver
adrian.klaver@aklaver.com