Re: [GENERAL] Making NULLs visible.

1998-10-09 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > > Yes, \ always outputs as \\, excepts someone changed it last week, and I > > am requesting a reversal. Do you like the \N if it is unique? > > Well, it's certainly clear, but could be confused with \n (newline). Can we > have \0 instead

RE: [GENERAL] Making NULLs visible.

1998-10-09 Thread Taral
> Yes, \ always outputs as \\, excepts someone changed it last week, and I > am requesting a reversal. Do you like the \N if it is unique? Well, it's certainly clear, but could be confused with \n (newline). Can we have \0 instead? Taral

Re: [GENERAL] Making NULLs visible.

1998-10-09 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > > How do you feel about displaying nulls as \N, as we do in the COPY > > output? > > And when I put \N in a text field? How do I distinguish? We need some kind > of escaping system here... like turn '\' into '\\' and then '\N' is unique >

RE: [GENERAL] Making NULLs visible.

1998-10-09 Thread Taral
> How do you feel about displaying nulls as \N, as we do in the COPY > output? And when I put \N in a text field? How do I distinguish? We need some kind of escaping system here... like turn '\' into '\\' and then '\N' is unique and non-textual. :) Also allows us to output control characters, etc

Re: [GENERAL] Making NULLs visible.

1998-10-09 Thread Bruce Momjian
> > > Is there a way to make postgreSQL 'show' nulls rather than have them appear > > > as blank fields? > > > I am always looking for suggestions on how to display nulls. It is on > > the TODO list. > > I'd suggest a query option. The query option could filter the displayed > data through a t

Re: [GENERAL] How to drop entries in a table?

1998-10-09 Thread Bruce Momjian
> Hi. > > I have a postgreSQL 6.3.2 and I want to delete an entry in a table. > > I tried a > "ALTER TABLE DROP COLUMN" > > but it replies: > "NOT YET IMPLEMENTED" > > h ... but it must be possible ... but how? See FAQ. -- Bruce Momjian| http://www.op.net/~can

Re: [GENERAL] Making NULLs visible.

1998-10-09 Thread Bruce Momjian
> Dear All, > > Is there a way to make postgreSQL 'show' nulls rather than have them appear > as blank fields? > > code|name > + > 5678| > | > (2 rows) > > brecard5=> select * from test; > code|name > +-- > 1234|one two three four > 5678| > | > | > (4 row