Is it possible to use subselects as joins in PostgreSQL.
eg.
select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a (second subselect)
b where (in table criteria) and a.a = b.a
or
select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a join (second
subselect) b on a.a = b.a wher
How do you extract postgresql column names, types and comments in tabular form,
using an SQL command?. I know they are stored in one of the system tables, but
I don't know which.
R Church
This message was sent using IMP, the Inter
Hi guys,
What is the command change database owner in PostgreSQL 7.4?
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast)---
TIP 9: In versions b
Quoting Andreas Kretschmer <[EMAIL PROTECTED]>:
> frank church <[EMAIL PROTECTED]> schrieb:
>
> > Hi guys,
> >
> > What is the command change database owner in PostgreSQL 7.4?
>
> ALTER DATABASE foo OWNER TO blob;
I tried that and it didn't work. T
Does VACUUMing reorder tables on clustered indices or is it only the CLUSTER
command that can do that?
/ r church
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast)
I am load lots of data via SQL into a database and wrapping it into transactions
speeds it up.
However this fails a number of times. The queries results are logged so it is
easy for me to find problem records.
However a single failure causes the whole transaction to fail.
Is there a setting or
I repeatedly get this error whenever I try to backup a database
The command used is:
pg_dump -Fc -O -U username tablename > tablename.20060122
pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
PQendcopy() faile
