Thread: firstest doubts...

firstest doubts...

From
"Roberto (SmartBit)"
Date:

Hi all,

I'm beginning in PosgreSQL and until now I may say that it is incredible ...

I have some sort asks ... and ... I hope be helped here.
so, first of all I should say that I am coming from Interbase, then:

1: There is any Postgres Language to InterBase like pgPL-SQL???

2: There is any tools to convert from Interbase to Postgres???

3: There is any Case tool like ER-Win that is compatible with Postgres??

4: The Interbase's DOMAIN is the same thing as Postgres's TYPES ?? And could
I create a TYPE without set an INPUT/OUTPUT function??
(ex. CREATE DOMAIN myDomain NUMERIC(12,2)


TIA

Roberto de Amorim - +55 48 346-2243
Software engineer at SmartBit Software
Delphi and Interbase consultant


Re: firstest doubts...

From
Justin Clift
Date:
"Roberto (SmartBit)" wrote:
>
> Hi all,
>
> I'm beginning in PosgreSQL and until now I may say that it is incredible ...

Cool!  :)

> I have some sort asks ... and ... I hope be helped here.
> so, first of all I should say that I am coming from Interbase, then:
>
> 1: There is any Postgres Language to InterBase like pgPL-SQL???

Yep, we have PL/pgSQL, and a bunch of others (PL/Tcl. PL/Perl,
PL/Python).

This will probably help:

http://www.postgresql.org/idocs/index.php?programmer-pl.html


> 2: There is any tools to convert from Interbase to Postgres???

Sure.  This will probably help:

http://techdocs.postgresql.org/#convertfrom

:)


> 3: There is any Case tool like ER-Win that is compatible with Postgres??

This page will probably be of assistance:

http://techdocs.postgresql.org/oresources.php#erdtools

As an additional tool, Tora now supports PostgreSQL:

http://www.globecom.se/tora/

:-)


> 4: The Interbase's DOMAIN is the same thing as Postgres's TYPES ?? And could
> I create a TYPE without set an INPUT/OUTPUT function??
> (ex. CREATE DOMAIN myDomain NUMERIC(12,2)

No idea.  Hopefully someone else can help you with this.

:-)

Regards and best wishes,

Justin Clift


> TIA
>
> Roberto de Amorim - +55 48 346-2243
> Software engineer at SmartBit Software
> Delphi and Interbase consultant
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi