in command line: psql template1 pgsql -l
in PSQL:
foodb=#> select datname from pg_database;
- Arash
>>> Achilleus Mantzios <[EMAIL PROTECTED]> 11/2/2004 10:21:06 AM >>>
O lorid ** Nov 2, 2004 :
> \z will list the tables in the dbase
> \d tablename will list the columns in the table
>
Hi All,
I have a table which has 'SERIAL' datatype. When I use 'create table X
as select * from my-table' , it creates the table but without serial
datatype. I mean without implicit sequence.
test=> \d qptuser
Table "public.qptuser"
Column | Type
Hi All,
We are having a performance problem with our database. The problem
exists when we include a constraint in GCTBALLOT. The constraint is as
follows:
alter table GCTBALLOT
add constraint FK_GCTBALLOT_GCTWEBU foreign key (GCTWEBU_SRL)
references GCTWEBU (SRL)
on delete restrict
