Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > postgresql > answers

How to know that a schema exist?

Newbie
  
Join Date: Dec 2006
Posts: 1
#1: Dec 11 '06
I want to delete a schema but first i want to know if it exist?

What can i do?

C U
Moderator
  
Join Date: Nov 2006
Location: Boston, USA
Posts: 505
#2: Dec 11 '06

re: How to know that a schema exist?

try this:
Expand|Select|Wrap|Line Numbers
  1. select nspname from pg_catalog.pg_namespace;
Reply

« previous question | next question »

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,358 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved