Is there a way to retrieve the name of the server in a query? something akin to
@@SERVERNAME on mssql.
toby
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Same error as before
Toby Doig
Software Development Manager
Vibrant Media
[EMAIL PROTECTED]
0207 239 0134
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gianni Mariani
Sent: 01 December 2003 16:37
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] UNICODE
A suggestion is to use a left outer join and then test for rows with a
right-hand null value (ones where the join failed).
The following example creates 2 tables, t1 and t2.
t1 has related records in t2 and the relation is indicated by
t1.rel->t2.id
create table t1 (
id integer,
rel integer,
labe
When I try to import data from a unicode file into PostgreSQL 7.4 under FreeBSD it
appears to now understand the Unicode file format.
To demonstrate I export a set of Integers into a Unicode file from MSSQL 2000. I samba
the file to a FreeBSD box and try to import from psql with COPY. It fails.
