Re: User defined table is not present in postgresql.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "MAJUMDER, SAYAN" <sayan(dot)a(dot)majumder(at)capgemini(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: User defined table is not present in postgresql.
Date: 2017-03-28 15:44:18
Message-ID: CAKFQuwb-ehXCsoF6i6u_4+Q+9wiy9=qbieNmgayEOoW44vhifg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Mar 28, 2017 at 2:35 AM, MAJUMDER, SAYAN <
sayan(dot)a(dot)majumder(at)capgemini(dot)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.​

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Korry Douglas 2017-03-28 15:51:31 Re: Integrating Postgresql with Active Directory
Previous Message czezz 2017-03-28 15:12:06 Odp: Re: [ADMIN] [ADMIN] Replication mode Master-Slave - maintenance question.