Postgres Pro
Downloads
Home   >   mailing lists

Re: User defined table is not present in postgresql. - Mailing list pgsql-admin

From David G. Johnston
Subject Re: User defined table is not present in postgresql.
Date
Msg-id CAKFQuwb-ehXCsoF6i6u_4+Q+9wiy9=qbieNmgayEOoW44vhifg@mail.gmail.com
Whole thread Raw
In response to User defined table is not present in postgresql.  ("MAJUMDER, SAYAN" <sayan.a.majumder@capgemini.com>)
List pgsql-admin
Tree view
On Tue, Mar 28, 2017 at 2:35 AM, MAJUMDER, SAYAN <sayan.a.majumder@capgemini.com> wrote:

Hi,

I am new to postgres and presently migrating from sql server to postgres and facing some problems. Kindly help me with this.

We have user defined table in sql server, I am unable to find the same in postgres. Postgres have the concept of Types but

The problem is I cannot set the default value of a column in Types available in postgres. I will be highly obliged if you solve me through

This.


​Um...

CREATE TABLE ... ?

https://www.postgresql.org/docs/current/static/sql-createtable.html

David J.​

pgsql-admin by date:

Previous
From: czezz
Date:
Subject: Odp: Re: [ADMIN] [ADMIN] Replication mode Master-Slave - maintenance question.
Next
From: Korry Douglas
Date:
Subject: Re: Integrating Postgresql with Active Directory