[SQL] RE: [SQL] Grass Root Protectioni sm

Thx, I could really use a good laugh! Bart van Houdt Syfact International B.V. Database developer T +31 (0)35 688 8209 M+31 (0)6 4938 8131 IMPORTANT: The information contained in this message is privileged and confidential, and protected from disclosure. If you are

Re: [SQL] Data length and data precision

Just what I needed, thx! -Oorspronkelijk bericht- Van: pgsql-sql-ow...@postgresql.org namens A. Kretschmer Verzonden: vr 6-2-2009 11:04 Aan: pgsql-sql@postgresql.org Onderwerp: Re: [SQL] Data length and data precision In response to Bart van Houdt : > Hi all, > > I'm t

[SQL] Data length and data precision

Hi all, I'm trying to write some code to make a 'fingerprint' of a database. This to compare a customer database with a reference database of our own. Therefore I'm trying to retrieve information like this: -Table name pg_class.relname where relkind = 'r' -Column name pg_attribute where attre

[SQL] Query to retrieve all indexed columns

get incorrect results... I'm having a hard time figuring out how to join pg_attribute.indkey in this, could anyone help me out on this one? Thanks in advance, Bart van Houdt Syfact International B.V. Database developer

Re: [SQL] Postgres version of all_ind_cols

Cool! Thx :D Bart van Houdt Syfact International B.V. Database developer -Original Message- From: Mario Splivalo [mailto:[EMAIL PROTECTED] Sent: dinsdag 11 november 2008 15:03 To: pgsql-sql@postgresql.org Cc: Bart van Houdt Subject: Re: [SQL] Postgres version of all_ind_cols Bart van

[SQL] Postgres version of all_ind_cols

each column with the following information: - index name - table name the index is on - column name the index is on - column position in the index - sort order Any help would be much appreciated :) Regards, Bart van Houdt Syfact International B.V. Database developer -- Sent via pgsql-sql ma

[SQL] RE: [SQL] Display message to use r

:) Regards, Bart van Houdt Syfact International B.V. Database developer From: Fernando Hevia [mailto:[EMAIL PROTECTED] Sent: dinsdag 4 november 2008 14:25 To: Bart van Houdt; pgsql-sql@postgresql.org Subject: RE: [SQL] Display message to user Hi Bart, If you are using psql then

[SQL] Display message to user

nt "SELECT migration_pkg.time_migration( $1 , $2 )" PL/pgSQL function "check_migration" line 34 at PERFORM Any help would be appreciated, Bart van Houdt Syfact International B.V. Database developer