--- Luke Pascoe <luke.p@kmg.co.nz> wrote:
> I have a table which defines various possible file
> delimiters (CHAR(1) NOT
> NULL), for the moment it'll only contain comma and
> tab. Inserting a comma is
> easy, but inserting a tab is proving somewhat more
> difficult.
>
> How do I do it in 'psql'?
>
--> Try using '\t' for tab.
Example : INSERT INTO table1(f1) values ('\t');
I'm not sure if inserting a TAB character will
cause some side-effects for commands like COPY FROM /
TO since these commands use tab to delimit fields.
Hope that helps,
ludwig
Hope that helps,
ludwig.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com