Anton Andreev wrote:
Hi,
Thank you for you detailed answer, but I am exactly in the case when I
want to paste the script and hit F5 and have both the database and
tables created.
>
A problem also comes from the fact that in order to use the query window
in pgadmin3, you need to select a database. Then when you create a new
database you can not access it by name cause you receive an error "cross
database referencing is not allowed".
You may be able to get your script to work with pgAdmin's restore option
(which seems to use pg_dump)
Try opening your script using the restore command in pgAdmin (Tools menu).
If it doesn't work, backup from pgadmin as a plain file and compare what
it puts out to what you have done.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
