On Jul 13, 9:12 am, adrian.kla...@gmail.com (Adrian Klaver) wrote:
On Monday 12 July 2010 10:18:07 pm A. Kretschmer wrote:
No, the reason is another:
test=# create table Stone(id serial);
NOTICE: CREATE TABLE will create implicit sequence Stone_id_seq for
serial column Stone.id
Hi,
I just finished defining a couple of tables with PgAdmin III and I'm
seeing something peculiar. I'm not sure what the problem is. When I
connect to the DB using psql and do \d table I get an error saying
that there's not relations by that name. What? When I do, \d I see
the tables listed.
On Apr 11, 5:45 am, [EMAIL PROTECTED] (Albe Laurenz) wrote:
Format the output.
For example, the 17408 in the query above is a result from the
first query.
If you had triggers, constraints, rules or indexes associated
with the table or the table would INHERIT another table, you'd probably
On Apr 9, 5:51 am, [EMAIL PROTECTED] (Albe Laurenz) wrote:
Andrew Falanga wrote:
I know about the -E option to psql and did that to get the following,
which is what psql does for a \d tablename:
* QUERY **
SELECT c.oid,
n.nspname,
c.relname
FROM
Hi,
I know about the -E option to psql and did that to get the following,
which is what psql does for a \d tablename:
* QUERY **
SELECT c.oid,
n.nspname,
c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE