A. Kretschmer (andreas.krets...@schollglas.com)

User Information

Display Name:

A. Kretschmer

Partial Email Address:

andreas.krets...@schollglas.com

Posts:

628	total
1	in PostgreSQL - Bugs
352	in PostgreSQL - General
125	in PostgreSQL - Novice
26	in PostgreSQL - Performance
133	in PostgreSQL - SQL

5 Most Recent

All Posts

1) A. Kretschmer Re: [GENERAL] Querying the schema for column widths - what syntax do I use?

+1 vote

am Thu, dem 21.02.2008, um 12:42:51 +0000 mailte Howard Wilkinson folgendes: Yes. Andreas...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

am  Thu, dem 21.02.2008, um 12:42:51 +0000 mailte Howard Wilkinson folgendes:
> SO I can do something like this?
> 
> select character_maximum_length from information_schema.columns where
> table_name='rr' and column_name='data';
> 
> Yes?

Yes.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

2) A. Kretschmer Re: [GENERAL] Querying the schema for column widths - what syntax do I use?

+1 vote

am Thu, dem 21.02.2008, um 10:44:32 +0000 mailte Howard Wilkinson folgendes:...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

am  Thu, dem 21.02.2008, um 10:44:32 +0000 mailte Howard Wilkinson folgendes:
> I am working on some upgrades to the MyDNS open source product. I have 
> some expertise in MySQL but am not overly familiar with PostgreSQL and 
> need some guidance on how to query the schema for the maximum size of 
> data a column can hold.
> 
> In MySQL I can do either: a "DESCRIBE" command or do "SELECT COLUMNS" 
> command. And then parse the result for the length in the type column of 
> the row returned. How would I do a similar function using PostgreSQL - I 
> have tried to find this in the manuals and in this mailing list but not 
> found any pointers to get me started.

http://www.alberton.info/postgresql_meta_info.html


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

3) A. Kretschmer Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

+1 vote

am Fri, dem 15.02.2008, um 11:39:53 +0800 mailte william folgendes: Of course, there are several...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

am  Fri, dem 15.02.2008, um 11:39:53 +0800 mailte william folgendes:
> Hello pgsql-general,
> 
>     Can send email from stored procedure in Postgres ?
> 

Of course, there are several solutions. For instance, use an untrusted
language like pl/perlU or pl/sh. Other solution:
pgmail from http://sourceforge.net/projects/pgmail/


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

4) A. Kretschmer Re: [GENERAL] installation problem

+1 vote

am Thu, dem 14.02.2008, um 7:35:15 +0000 mailte First NameBipllab Roy folgendes: Disable UAC....

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

am  Thu, dem 14.02.2008, um  7:35:15 +0000 mailte First NameBipllab Roy folgendes:
> I am having problem installing the postgre vre 8.2 in windows vista. during the
> installation period it displays the error mesage user postgres cannot be
> created access denied and suddenly the installation fails. please give me
> suggestion in this regard.

Disable UAC.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

5) A. Kretschmer Re: [GENERAL] show time consumed by query in psql

+1 vote

am Wed, dem 13.02.2008, um 10:22:29 +0100 mailte Willy-Bas Loos folgendes: \timing Andreas...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

am  Wed, dem 13.02.2008, um 10:22:29 +0100 mailte Willy-Bas Loos folgendes:
> How can i make psql report the amount of time that was consumed in the query??
> I´ve seen a couple of posts that refer to this, but everyone seems to solve it
> in some other way. Is this not a feature of psql? (it should be!)

\timing



Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Highlight

Profile | Posts (628)

Home > People > A. Kretschmer