netkof=> show client encoding;
ERROR: parser: parse error at or near "encoding"
netkof=> set client encoding to 'WIN1250';
ERROR: parser: parse error at or near "encoding"
netkof=> set client-encoding to 'WIN1250';
ERROR: parser: parse error at or near "-"
Hmm, what did you say I should write?
I've got an external C function that I call from a SELECT, for example:
select * from where and CFunction(columnName) > 1.0;
The 'CFunction' has been installed into Postgreql using CREATE FUNCTION,
with a single 'text' argument, and returning a float8 (i.e. double).
I can tell that the 'CFunc
"Robert" == Robert <[EMAIL PROTECTED]> writes:
Robert> Hi, ISO-8851-2 Czech support (esp. sorting) works fine, but my
Robert> data use Win1250. PG 6.5.1+ is supposed to support it, can some
Robert> kind soul tell me how can I use it? Thanks.
Robert> - Robert
Just do:
set
How can I get a listing from the postmaster about what databases exist
on the machine?
so if I had
template1
phone_numbers
friend
as three db on my machine is there a SQL that will tell me what they
are??
> > By the way, I know about using pg_dump to backup the database and I do
> > that. Is there a good way to maintain a second identical copy of the
> > database on another machine? Will simply copying the dump over and
> > restoring it with psql do the trick? Would I need to delete an old
