ommand, things will be more
complicated.
If you have not modified system catalogs in template1, 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
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.
&
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?
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
postgres$# END;
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
ou can try Borland C++'s tool implib.exe.
1) Start a command line box.
2) 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
--
"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
-
create table foo (fno int, ftimestamp timestamp default now());
insert into foo(fno) values (1);
insert into foo(fno) values (2);
select * from foo;
Regards,
William ZHANG
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please se
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
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" <[EMA
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
> 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
