Hi list,
how can I list the databases in a postgresish way? I know about the '-l'
switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
an external program only to list the databases. I've googled about this
problem but I only found the '-l'-way to this this.
Ideas? Solutions
At 07:13 AM 11/1/04, Erik Wasser wrote:
how can I list the databases in a postgresish way? I know about the '-l'
switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
an external program only to list the databases. I've googled about this
problem but I only found the '-l'-way to t
On Mon, 1 Nov 2004 13:13:10 +0100, Erik Wasser <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> how can I list the databases in a postgresish way? I know about the '-l'
> switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
> an external program only to list the databases. I've googled
On Monday 01 November 2004 13:26, Ian Barwick wrote:
> Start psql with the -E switch, and it shows the SQL used to generate
> the output from psql's slash commands.
Thanks for the quick answer. I will remember this switch! B-)
--
So long... Fuzz
---(end of broadcast)---
Hello,
I have created the following join table: the two FKs are the PK of the
table. Typically, I will need to select rows for a given ITEM_FK.
Question: is it necessary/advisable to create an index for the ITEM_FK
column? Or is this redundantbecause this column is already one of the PK
columns
On Mon, Nov 01, 2004 at 04:34:32PM +, T E Schmitz wrote:
>
> I have created the following join table: the two FKs are the PK of the
> table. Typically, I will need to select rows for a given ITEM_FK.
>
> Question: is it necessary/advisable to create an index for the ITEM_FK
> column? Or is
T E Schmitz <[EMAIL PROTECTED]> writes:
> CREATE TABLE SUPPLY
> (
> ITEM_FK integer NOT NULL,
> CONTACT_FK integer NOT NULL,
> COST numeric (7,2),
> PRIMARY KEY (ITEM_FK,CONTACT_FK)
> );
> Question: is it necessary/advisable to create an index for the ITEM_FK
> column? Or is this redundantbecause
T E Schmitz wrote:
Hello,
I have created the following join table: the two FKs are the PK of the
table. Typically, I will need to select rows for a given ITEM_FK.
Question: is it necessary/advisable to create an index for the ITEM_FK
column? Or is this redundantbecause this column is already one
Hello Mike/Tom/Richard,
Thank you for your replies.
Michael Fuhr wrote:
On Mon, Nov 01, 2004 at 04:34:32PM +, T E Schmitz wrote:
Question: is it necessary/advisable to create an index for the ITEM_FK
column? Or is this redundantbecause this column is already one of the PK
columns?
However, r
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> how can I list the databases in a postgresish way? I know
> about the '-l' switch of 'psql' but is there a DBI/SQL-query way?
Yes, the DBI way is to use the "data_sources" function. Works
just fine for Postgres:
my @dbs = DBI->data_sources(
On Mon, Nov 01, 2004 at 06:12:02PM +, T E Schmitz wrote:
> I see. If using a multi-column PK, the order matters.
> So, if I want to access the table both via the 1st and 2nd PK column, I
> would have to define an index for the 2nd column to avoid a full table scan.
If you want to use an inde
11 matches
Mail list logo