On Fri, 24 Aug 2001 21:53:00 GMT, uncleleo <[EMAIL PROTECTED]> wrote:
> I am attemping to create multiple databases with Postgresql ver. 7.0.3
> running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0.
>
> Can someone tell me how I can connect to different databases in a singl
On Wed, Jun 13, 2001 at 07:25:46PM +0200, Nils Zonneveld wrote:
>
>
> Carfield Yim wrote:
> >
> > I am a new user of PostgreSQL dbms, how can I check how many tables
> > avaliable at that database?
>
> To get a list of tables through SQL:
>
> SELECT tablename FROM pg_tables WHERE tablename N
On Tue, May 29, 2001 at 07:49:46PM -0400, Arcadio A. Sincero Jr. wrote:
> Hello list,
wrong list. try [EMAIL PROTECTED] instead.
> I'd like to set up Postgresql so that users can have "read-only" access to a
> database. Right now, I only know how to set it so a user can have all or
> nothing ac
On Tue, 1 May 2001, Clay & Judi Kinney wrote:
> How do I create an autoincrement field in a postgresql table???
>
> What are the correct field type and parameters
>
> Any help would be appreciated.
CREATE TABLE foo (
id SERIAL,
...
)
it comes out as an int4 or integer type.
--
J
You *really* should go glance over the manual.. There is the field type
SERIAL and things called sequences, both could be what you're talking
aboutThe rest I'll leave up to you :-)
Good luck!!!
-Mitch
- Original Message -
From: "Clay & Judi Kinney" <[EMAIL PROTECTED]>
To: <[EMAIL PR
On Tue, 10 Apr 2001, Cefull Lo wrote:
> When I type INSERT INTO friend
> VALUES ('', '', '');
> it returns
> INSERT 19748 1
>
> what means of 19748 and 1?
It's the OID, a unique idenifier for everything in the database.
Read the Momjian book on the website -- it explains this very well.
--
Jo
Oh and the instructions in the INSTALL file (under the directory where the
source was un-tar'd) is very easy to follow and walks you through the
installation as much as possible IMHO..
The user/admin/programmer manuals and the tutorial @ www.postgresql.org are
all good too, they detail just abou
If you're talking about some kind of C application then it's going to be
portable only you'll have to rip out the PG API and replace it with the
Oracle API, I'm sure that's not such an easy task..
If you're speaking of an application written in say, PHP, then that's a
horse of a different color.
