[SQL] Some problem with inet type on PostgreSQL-7.0

Hi All, I have some problem with inet type on PostgreSQL-7.0 (FreeBSD 3.4-STABLE) Table "ipaddresses" Attribute | Type | Modifier --+-+ sysname | text| not null index| integer | not null

[SQL] inheritance and primary key

Hi, Is primary key similar to 'not null columns with indices'? The reason I am asking because I found that when you inherit table B from table A, the primary key in A won't be inherited to B, but only the columns. I was wondering how do you inherit a primary key or, even, a foreign key? If it'

[SQL] Outputting the Tables of a database

Hello all, What would the query line be to mimic mydb=>\d tablename ? I have been able to run a query to mimic #psql -l and to mimic mydb=>\d thanks for the help Brian

Re: [SQL] Outputting the Tables of a database

You could possibly use grep and awk to filter the output. See "man grep" and "man awk" for details. "Brian C. Doyle" wrote: > Hello all, > > I am trying to out put the tables of a database. I have > > psql -d mydb -c "\d" > > This works but I am looking at turning on the html out put which it w

[SQL] Outputting the Tables of a database

Hello all, I am trying to out put the tables of a database. I have psql -d mydb -c "\d" This works but I am looking at turning on the html out put which it will not do. If I am able to get just the table titles that would be most ideal.

[SQL] Re: Simple search question

Alex <[EMAIL PROTECTED]> writes: > Hi, > after running a script which performs an insert, a new tuple is > created, and a serial number is generated for it. I want to write the > new tuple data back to the screen, including the new serial number. > My question is, do I have to do a search for

[SQL] attribute error

Hi, Im rather new to postgres so please exuse my ignorance. I have a table that I would like to drop, only problem is it wont let me. I keep getting the error message: Cannot find attribute 5 of relation tablename. Can anyone explain to me what this means and how I can resolve this issue. Fr

Re: [SQL] Q:Postgres 7.0 & Access'97?

Hello Emils, Once, Tuesday, June 13, 2000, 8:42:05 PM, you wrote: EK> I am using Postgres 7.0 on SuSE Linux 6.2 and Postdrv.exe EK> 6.50. (as downloaded from /latest/ dir of PG FTP site EK> yesterday). EK> Now, I have experienced 4 issues immediately with Postgres via EK> ODBC from Access