Andreas <[EMAIL PROTECTED]> writes:
> could I get a list of foreign keys that refer to a column?
The information_schema views constraint_column_usage and
referential_constraints might help you, or you could dive into the
underlying system catalogs.
regards, tom lane
-
Erik Jones wrote:
> >>> On the way back, likewise I could pipe the tape through dd before
> >>> giving it
> >>> to pg_restore.
> >>>
> >>> Does pg_dump care what blocksize it gets? If so, what is it?
> >>
> >> I assume you could pipe pg_dump into dd and specify the block size in
> >> dd.
> >>
> >
On Aug 26, 2007, at 8:09 PM, Jean-David Beyer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
Jean-David Beyer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
When I make a backup of a database, I put the output file
directly on
magnetic tape; i.e., my comma
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
> Jean-David Beyer wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> When I make a backup of a database, I put the output file directly on
>> magnetic tape; i.e., my command looks like this:
>>
>> pg_dump --file=/dev
Jean-David Beyer wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> When I make a backup of a database, I put the output file directly on
> magnetic tape; i.e., my command looks like this:
>
> pg_dump --file=/dev/st0
>
> This way I do not have to worry if the total backup exceeds
Hi,
could I get a list of foreign keys that refer to a column?
Say I have a table_1 (t1_id integer ..)
and a lot of other tables that may refer to table 1.
Is there a command that lists all tables that have a foreign key that
points to t1_id?
Preferably with the "on update/delete" optio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
When I make a backup of a database, I put the output file directly on
magnetic tape; i.e., my command looks like this:
pg_dump --file=/dev/st0
This way I do not have to worry if the total backup exceeds the size of a
file system, and it saves me
