Hi,
I have an existing table and want to change the type of a column from text to oid.
I have tried pg_dumping and psql -e, but get "broken pipe" when inserting the date
into the new table.
pastgresql 6.4 on linux
thanks for your help
timj
[EMAIL PROTECTED]
At 08:16 +0300 on 26/07/1999, Dan Wilson wrote:
> SELECT typname from pg_type WHERE NOT LIKE '_%'
>
> It gives me an empty set.
>
> Is there any way to escape the underscore. I tried to use '\_%', but that
> didn't help. Any suggestions?
Yes. Use '\\_%' instead. You see, a backslash is interp
