Was thinking of installing Gitorious but it's weird. You run install
as root, it downloads and installs programs, dunno which ones, seems
you don't need to know, but including mysql, and then of all things it
wants you to reboot the host, i.e. it needs a host dedicated to
Gitorious. It seems you
On Wed, 15 Aug 2012, Neanderthelle Jones wrote:
> So it seems to us that the lo_export output can't be piped (via a
> named pipe) to another process that reads from the pipe and expects
> the valid BLOB contents.
I should have said that the BLOB is a PDF and the file that results
We are getting a strange thing happening if the lo_export(attr, path)
destination is a fifo.
First, in the normal case, there is output to the file but also
feedback to stdout (or somewhere, appearing on the VT screen) of the
number 1.
---
1
(1 row)
Now, if the destination file
On Sun, 12 Aug 2012, Tom Lane wrote:
> Neanderthelle Jones writes:
> > One attempt. Is the error mine or PostgreSQL's?
>
> > $ for i in $(psql -q -t -U elle -d my_db \
> > -c "SELECT raster FROM images where raster > 0"); do
> > echo $i
>
On Mon, 13 Aug 2012, Neanderthelle Jones wrote:
>
> $ for i in $(psql -q -t -U elle -d my_db \
> -c "SELECT raster FROM images where raster > 0"); do
> echo $i
> psql -q -U elle -d my_db -c "SELECT lo_unlink($i)"
> done
"BEGIN; SELECT lo_unlin
On Sun, 12 Aug 2012, Neanderthelle Jones wrote:
> I'd like to delete all the image files from a table by issuing an
> interactive psql command. Given
>
> CREATE TABLE image (
> name text,
> rast oid
> );
>
> with most tuples having images
I'd like to delete all the image files from a table by issuing an
interactive psql command. Given
CREATE TABLE image (
name text,
rast oid
);
with most tuples having images in rast, wanna do something like
=> select lo_unlink('select rast from image');
Can such a thing be done,
On Fri, 27 Mar 2009, Mauro Bertoli wrote:
> SELECT
> db1.a.id FROM db1.a
> UNION
> db2.b.id FROM db2.b
>
> Where "db1" is a database and "db2" is another database. "a" is a
> table in database "db1" and "b" is a table in database "db2"
You might be able to create the equivalent of a union
On Tue, 17 Mar 2009, Sam Mason wrote:
> You're putting things in the wrong places! The "E" says that the
> following literal is using C style escaping. I.e. you want to say:
>
> E'Smith \\& Jones'
Thanks. Now I understand.
Elle.
--
Sent via pgsql-general mailing list (pgsql-general@post
About the string "Smith \& Jones".
According to the documentation,
INSERT INTO thing (name) VALUES ('Smith E'\\'& Jones');
must work. But it doesn't. So, double the enclosed quotes:
INSERT INTO thing (name) VALUES ('Smith E''\\''& Jones');
Doesn't.
It works fine, but with a warning, as
INS
10 matches
Mail list logo
