Re: PostgreSQL on testing
El Mié 28 Sep 2005 10:29, Jim Buttafuoco escribió:
> what does table/view hijo look like
It doesn't matter to much, as it happens with other tables, and even other DB.
What ever, this it hijo:
prueba=> \d hijo
Tabla «public.hijo»
Columna | Tipo | Modificadores
---------+-----------------------+-------------------------------------------------------
id | integer | not null default
nextval('public.padre_id_seq'::text)
c1 | character varying(20) | not null
c2 | character varying(40) |
Hereda: padre
prueba=> \dt
Listado de relaciones
Schema | Nombre | Tipo | Dueño
--------+----------+-------+--------
public | hijo | tabla | martin
public | horas | tabla | martin
public | padre | tabla | martin
public | pruebita | tabla | martin
(4 filas)
prueba=> \d horas
Tabla «public.horas»
Columna | Tipo | Modificadores
---------+------------------------+-------------------------------------------------------
id | integer | not null default
nextval('public.horas_id_seq'::text)
hora | time without time zone |
prueba=> CREATE VIEW prueba AS
prueba-> SELECT hora FROM horas;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
La conexión al servidor se ha perdido. Intentando reiniciar: falló.
--
10:31:39 up 11 days, 15:48, 2 users, load average: 1.39, 1.45, 1.32
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------
Reply to: