nt from my smartphone
You can try DbVisualizer at www.dbvis.com, even the Freeware Version is good.
Johan Nel
Durban, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nd not other tables columns... using the below:
delete from pg_attribute where attrelid = regclass 'yourviewname' and attname =
'columnnametodrop'
Best to first do couple of selects until you have the selection correct:
select attrelid::regclass as whatever, * from pg_attrib
ifferent
thing from single vendor software, where support will continue as long as the
vendor finds it worthwhile to provide it.
Best Wishes,
Chris travers
Not to forget that Skype has used PostrgeSQL from the start... Probably a very
good case study to use that PG is mainstream enough.
Johan Nel
South Africa.
nge the TYPE of a
column.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the data.
3. You have an application that have an option to insert the current
datetimestamp into your dumplog table and then read the exported table
after completion.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
_user.
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Yes I agree, that was why I initially said to do a couple of selects
before doint the update to ensure only the applicable columns get
updated.
>> Just first do some select statements to ensure you only
>> update what you really want to.
Regards,
Johan Nel
Pretoria, South Africa
a drop and
recreating of the queries without any side effects.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
direction will
either drown in their own information pollution or loose millions on
systems that are late, cost too much, and atrophy too quickly.”
Regards,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
something Timeout=60 or bigger.
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
know, exactly what I am using for
all my front-end applications.
Regards,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t almost impossible to have not more than
50% of a table's columns redundant.
If you need more info regarding this approach, feel free to contact me in
private.
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
w5~row9 | 3
row4 | row2 | 1 | row2~row4 | 4
row6 | row4 | 2 | row2~row4~row6 | 5
row8 | row6 | 3 | row2~row4~row6~row8 | 6
(6 rows)
Regards,
Johan Nel
Pretoria, South Africa.
Keresztury Balázs wrote:
hi,
I'm currently developing a
'\\'
I took the code directly from the help files for Npgsql. My question, how
do one use the E'\\' on a bytea column that is passed into a NpgsqlCommand
statement using NpgsqlParameter?
TIA,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-ge
are more than enough.
However the moment you start having to reference the spatial data to a
position on earth, you really cannot use anything else than PostGIS.
So in general, of you have spatial features all starting with a
reference point of (0,0) use the build-in support.
HTH,
Johan Nel
e", FileMode.Create,
FileAccess.Write);
BinaryWriter bw = new BinaryWriter(new BufferedStream(fs));
bw.Write(result);
bw.Flush();
fs.Close();
bw.Close();
conn.Close();
}
}
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pg
a "Expiry
flag/Inactive flag" on your user table to allow old records to be
viewed, but records can only be inserted/updated/deleted by current
active users. In this scenario, your user DELETE re-root your delete
statement to only deactivate the user from logging into the database.
t case:
You probably don't need to do anything except making sure that the
server and PG allows access from the IP address range used at the branch
office.
From the branch office you need to make your connection point to the IP
address of the PG server...
HTH,
Johan Nel
Pretoria, South A
again
END;
END LOOP;
END;
$$
LANGUAGE plpgsql;
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;
LOOP
IF rec.credit < 0 THEN
...
ELSE
...
END IF;
END LOOP;
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
DaNieL..! wrote:
I tryed the declare, before and after the BEGIN;, but allways returns
me the error:
---
ERROR: syntax error at or near "int";
LINE 1: DECLARE _mycredit int;
^
--
OO is defined in programming languages, it is clear
that Cache follow a design nearer to programming language implementation.
So from my perspective, PG is not really a OO DB. We can however
through design make it to emulate OO, but it is not forced.
My 2cents worth.
Johan Nel
Pretoria
r the above, it does not need to be exactly the same, but are there a
group of functions available to at least return in a dynamic query the
number of columns, name of a column given the ordinal number of the
column, etc?
TIA,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general
into the central database.
Regards,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
IP address range that you want to
connect from, similar to:
host all all 10.0.0.1/8 md5
Remember to reload your configuration.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
#x27;, 'id', 'parentid', '',
0, '~')
AS t(keyid text, parent_keyid text, level int, branch text);
HTH,
Johan Nel
Durban, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the server.
HTH,
Johan Nel
Pretoria, South Africa.
Martin Roach wrote:
Hi
I started the installation of postrgres got distracted and then started
again but forgot my password. I have received the info below:
Now what?
If you have access to shell account on the machine PostgreSQL is
running
27 matches
Mail list logo
