Re: [GENERAL] How to get comments for view columns?

2007-05-07 Thread eugene . mindrov
Tom Lane wrote: > What do you consider "selected"? Given a view defined as > > select a, b, c+d as sum from tab where e > 42; > > what output are you wishing for? > > AFAIR the dependency mechanism will treat a,b,c,d,e alike. To do more > you'd need to grovel through the pg_rewrite express

[GENERAL] How to get comments for view columns?

2007-05-03 Thread eugene . mindrov
Hi, is there any way to get comment meta-information for columns in a view? I mean, suppose I have several tables and some of their columns have comments, then I define a view on these tables, and what I want is to somehow retrieve comments (if any) for those columns which are selected in a view. I

Re: [GENERAL] COPY FROM file with zero-delimited fields

2007-04-13 Thread eugene . mindrov
On Apr 11, 7:42 pm, [EMAIL PROTECTED] ("Merlin Moncure") wrote: > On 11 Apr 2007 00:25:50 -0700, [EMAIL PROTECTED] > > <[EMAIL PROTECTED]> wrote: > > Hi all, > > I wonder if there's a way to use COPY FROM command when dealing with a > > data file containing records whose fields are delimited with z

[GENERAL] COPY FROM file with zero-delimited fields

2007-04-11 Thread eugene . mindrov
Hi all, I wonder if there's a way to use COPY FROM command when dealing with a data file containing records whose fields are delimited with zero- byte? Or I'd better change the delimiter? :) ---(end of broadcast)--- TIP 4: Have you searched our list