--- Luke Pascoe <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]