>>> Jackson, DeJuan wrote:
>>> > > Martin Schulze wrote:
>>> > > > . I wonder how one could add or remove columns from existing tables.
>>> > > >
>>> > > > With mSQL this was possible with a trick. You had to dump the
>>> > > > whole table but you could tell the dump prog
Is there a good guise for system admin? I am stumped on the most
mundane problem right now: how do I set user passwords in postgresql?
When I createuser I never get prompted for a password, when I run psql
with no parameters I get right in, but if I run:
"psql -u someone"
I get a password prompt
On Fri, 2 Oct 1998, Oliver Elphick wrote:
> Copied to PostgreSQL lists, in the hope of comments from the experts...
>
> Martin Schulze wrote:
> >Is there a way to speed up postgres? I'm converting one of my
> >major apps from mSQL to PostgreSQL and PostgreSQL is at least three
> >times sl
On Fri, 2 Oct 1998, Oliver Elphick wrote:
> > . I wonder how one could add or remove columns from existing tables.
> >
> > With mSQL this was possible with a trick. You had to dump the
> > whole table but you could tell the dump program to add dummy fields
> > or to leave out exi
> On Fri, 2 Oct 1998, Oliver Elphick wrote:
>
> > > . I wonder how one could add or remove columns from existing tables.
> > >
> > > With mSQL this was possible with a trick. You had to dump the
> > > whole table but you could tell the dump program to add dummy fields
> > > or to
John Guthrie wrote:
>Is there a good guise for system admin? I am stumped on the most
>mundane problem right now: how do I set user passwords in postgresql?
>When I createuser I never get prompted for a password, when I run psql
>with no parameters I get right in, but if I run:
> "psql
Hi.
I have a question regarding programming in C and
postgreSQL.
Is there any way that I can save couple of
results to one PGresult * ??
Like
thisBEGIN;DECLARE portal1 CURSOR FOR select
* from item where item = 'aa';DECLARE portal2 CURSOR FOR select * from item
