Re: [SQL] Foreign key columns

On Thu, Nov 5, 2009 at 2:08 PM, Svenne Krap wrote: > Hi. > > Is there a simple way to get foreign key data... for example I found a > view, that does what I want ... > > It delivers > >   fk_table   |     fk_column      |     pk_table      | pk_column |           > constraint_name > > ---

[SQL] Foreign key columns

Hi. Is there a simple way to get foreign key data... for example I found a view, that does what I want ... It delivers fk_table | fk_column | pk_table | pk_column | constraint_name --++---+---+

Re: [SQL] Converting T-SQL to PostgreSQL

2009/11/5 Pavel Stehule : > Hello > > 2009/11/5 maboyz : >> >> I am trying to re write the following stored proc as a postgresql >> function..but am new to postgres and it is kind of getting really >> confusing trying to learn and let alone understand the syntax: >> >> CREATE PROCEDURE [dbo].[G

Re: [SQL] Converting T-SQL to PostgreSQL

Hello 2009/11/5 maboyz : > > I am trying to re write the following stored proc as a postgresql > function..but am new to postgres and it is kind of getting really > confusing trying to learn and let alone understand the syntax: > > CREATE PROCEDURE [dbo].[GetAppAvailability] >       �...@audit

[SQL] Converting T-SQL to PostgreSQL

I am trying to re write the following stored proc as a postgresql function..but am new to postgres and it is kind of getting really confusing trying to learn and let alone understand the syntax: CREATE PROCEDURE [dbo].[GetAppAvailability] @AuditAvailable bit output, @B