, using template0 in
dump
should cause no problem.
Regrads,
William ZHANG
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Re: [GENERAL] partial resultset in javaI have not install pgsql's jdbc. But
I think the following link may help.
Regards,
William ZHANG
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
Sorry. Forgot the link:
http://www.onjava.com/pub/a/onjava/2004/06/16/dbcancel.html?page=2
William ZHANG [EMAIL PROTECTED]
Re: [GENERAL] partial resultset in javaI have not install pgsql's jdbc.
But I think the following link may help.
Regards,
William ZHANG
;
postgres$# $$ LANGUAGE plpgsql;
CREATE FUNCTION
postgres=# SELECT foo ('pgsql', 'hackers');
foo
---
pgsql\hackers
(1 row)
Regards,
William ZHANG
---(end of broadcast)---
TIP 6: explain analyze is your friend
There is a method called cancel() in interface Statement. But I don't know
if it is
implemented correctly in JDBC. Maybe you can try it.
Regards,
William ZHANG
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
Sigurdur Gunnlaugsson [EMAIL PROTECTED]
On Mon, 2006-03-20 at 21:10, Wei Wei wrote:
Try:
order by count(id)/age::float
Or you can use the standard grammer:
order by cast(count(id)/age as float)
Regards,
William ZHANG
---(end of broadcast
) Change to the directory where implib.exe resides.
3) Run implib. It is something like:
implib libpq.lib libpq.dll
But I can not verify it now. Please try it.
Regards,
William ZHANG
---(end of broadcast)---
TIP 3: Have you checked our
into foo(fno) values (2);
select * from foo;
Regards,
William ZHANG
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
Sybase and Microsoft SQL Server are somewhat silimar on
the concept `database'. They both support queries across
multiple databases. But pgsql's database is different,
I think you can use pgsql's schemas to cope with problem.
Regards, William ZHANG
Cosmopo [EMAIL PROTECTED] wrote
Hello,
I
Yes, the Makefiles cannot deal with spaces correctly.
Seems we should avoid use the `complicated' path.
Wes [EMAIL PROTECTED] wrote
System: Mac OS X 10.4.2
PostgreSQL: 8.1 b2
Running 'make check', I get the following failure:
rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh
pgsql stores table names in pg_class.relname, column names in
pg_attribute.attname.
Read the document and you can get the solution.
Emi Lu [EMAIL PROTECTED] wrote
Greetings,
I am not very familiar with the system views/tables in postgreSQL. I'd
like to get all table names that have a column
My question: where in the FTP area is the HTML manual for version 8.0?
ftp://ftp.postgresql.org/pub/v8.0.3/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
e.g.
pg_shadow_usename_index
pg_stat_activity
pg_stat_database
They are system views and correspond to no file.
See PostgreSQL's documents.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Steven O. [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]
First, this may not be the correct newsgroup. I have some relatively
basic questions on SQL. I tried to find a newsgroup that was
specifically just about SQL, and was surprised to find that all the
SQL-related newsgroups seem to be
14 matches
Mail list logo